解å³Mysqlæ æ³è¿ç¨è¿æ¥çé®é¢ï¼å¯ä»¥ä»ä»¥ä¸å 个ç¹å»æ£æ¥ä¸ï¼
1ãMysqlç端å£æ¯å¦æ£ç¡®
éè¿netstat -ntlp æ¥ç端å£å ç¨æ
åµï¼ä¸è¬æ
åµä¸ç«¯å£æ¯3306ãå¨ç¨å·¥å
·è¿æ¥MySQlæ¯è¦ç¨å°ç«¯å£ãä¾å¦My Admin\My Query Browser\MySQl Frontçã
2ãæ£æ¥ç¨æ·æéæ¯å¦æ£ç¡®
mysqlåºçuser表éæ两æ¡è®°å½ï¼hoståå«ä¸ºlocalhostå%(为äºå®å
¨ï¼%å¯ä»¥æ¢æä½ éè¦å¤é¨è¿æ¥çIP)ã
3ãæ¥çiptablesæ¯å¦åæ,没å
³çæ
åµä¸,æ æ³è¿æ¥
éè¿ï¼service iptables stop临æ¶å
³éã
æ¥éï¼ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.51.112' (113)
4ãæmy.cnfä¸çbind-address注éæï¼ç¶åéæ°å¯å¨mysqlæå¡å¨ç¨åºsudo /etc/init.d/mysql restartã
5ãæ£æ¥ä¸ç¨æ·åå¯ç åè¿ç¨ä¸»æºæ¯å¦å¯¹ä½ çIPå¼æ¾æéã
温馨提示:答案为网友推荐,仅供参考