How to find out mySQL server ip address from phpmyadmin

Question

I have access to my server s phpmyadmin  But how can I find that mysql s Ip address from phpmyadmin  My webserver and mysql is using different IPs    Is there any way to find this out

User · Answer

You can ssh to your server and run this command   ln -s  usr share phpmyadmin  var www phpmyadmin   It worked for me

User · Answer

The server s address is stored in config php

User · Answer

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

User · Answer

As an alternative  since you know the hostname  resolve the database server IP via  hostname from the web server   http   php net manual en function gethostbyname php

User · Answer

MySQL doesn t care what IP its on  Closest you could get would be hostname   select   from GLOBAL variables where variable name like  hostname

User · Answer

select   from SHOW VARIABLES WHERE Variable name    hostname

[mysql] How to find out mySQL server ip address from phpmyadmin

Examples related to mysql

Examples related to phpmyadmin