é»è®¤æ åµä¸ï¼mysqlåªå 许æ¬å°ç»å½ï¼å¦æè¦å¼å¯è¿ç¨è¿æ¥ï¼åéè¦ä¿®æ¹/etc/mysql/my.confæ件ã
ä¸ãä¿®æ¹/etc/mysql/my.conf
æ¾å°bind-address = 127.0.0.1è¿ä¸è¡
æ¹ä¸ºbind-address = 0.0.0.0å³å¯
äºã为éè¦è¿ç¨ç»å½çç¨æ·èµäºæé
1ãæ°å»ºç¨æ·è¿ç¨è¿æ¥mysqlæ°æ®åº
grant all on *.* to admin@'%' identified by '123456' with grant option;
flush privileges;
å
许任ä½ipå°å(%表示å
许任ä½ipå°å)ççµèç¨adminå¸æ·åå¯ç (123456)æ¥è®¿é®è¿ä¸ªmysql serverã
注æadminè´¦æ·ä¸ä¸å®è¦åå¨ã
2ãæ¯ærootç¨æ·å
许è¿ç¨è¿æ¥mysqlæ°æ®åº
grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;
flush privileges;
ä¸ãæ¥çç³»ç»ç¨æ·