Menu
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?
530
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. Show activity on this post. Show activity on this post.
For connecting remotely using the IP address/domain of your MySQL database, open the Variables menu from your phpMyAdmin homepage and search for “hostname” to get the actual domain or IP address of the database server: The phpMyAdmin homepage can be accessed by clicking on the logo in the top-left corner.
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
56
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
