如何从phpmyadmin中找出mySQL服务器的IP地址 [英] How to find out mySQL server ip address from phpmyadmin

问题描述

我可以访问服务器的phpmyadmin.但是我怎么能从phpmyadmin找到那个mysql的IP地址呢.我的网络服务器和mysql使用不同的IP.

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?

推荐答案

SQL查询 SHOW VARIABLES WHERE Variable_name ='hostname'将为您显示MySQL服务器的主机名，您可以轻松地将其解析为它的IP地址.

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变量在哪里Variable_name ='port'将为您提供端口号.

有关详细信息，请参见MySQL手册:12.4.5.41.显示变量语法和5.1.4.服务器系统变量

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

这篇关于如何从phpmyadmin中找出mySQL服务器的IP地址的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！