具体方法：首先打开命令提示符；然后执行【mysql -u root -p】命令进入mysql；最后执行如下命令即可：select SUBSTRING_INDEX(host,':',1) as ip , count(*) from information_schema.processlist group by ip;到此这篇关于查看连接mysql的IP地址的..
1.登录mysql： mysql -u root -h 127.0.0.1 -p2.切换数据库 use mysql3.授权grant all privileges on *.* to 'root'@'127.0.0.1'identified by '密码'; 将127.0.0.1换成公网的ip地址。4.检查my.ini 4.1 看看是否有skip-networking skip-networking..
