How to find out mySQL server ip address from phpmyadmin

The SQL query SHOW VARIABLES WHERE Variable_name=”hostname” will show you the hostname of the MySQL server which you can easily resolve to its IP address.

SHOW VARIABLES WHERE Variable_name=”port” Will give you the port number.

You can find details about this in MySQL’s manual: 12.4.5.41. SHOW VARIABLES Syntax and 5.1.4. Server System Variables

Leave a Comment