轉(zhuǎn)載:http://blog.csdn.net/chana1101/article/details/39641415
http://www.cnblogs.com/ohmydenzi/p/5521121.html
ubuntu server16.04.1下安裝了MySQL 5.7數(shù)據(jù)庫(kù),然后在windows下通過Navicat for MySQL連接時(shí),出現(xiàn) Can't connect to mysql server on xxx.xxx.xxx.xxx(10038) 的問題。
解決方案如下:
1、授權(quán)
mysql>grant all privileges on *.* to 'root'@'%' identified by 'youpassword' with grant option;
mysql>flush privileges;
2、修改 /etc/mysql/mysql.conf.d ( 老版本的是這個(gè)目錄:/etc/mysql/my.conf )
找到bind-address = 127.0.0.1這一行
改為bind-address = 0.0.0.0即可
如果還沒解決可能是遠(yuǎn)程端口(3306)未對(duì)外開放。
參考:http://jingyan.baidu.com/article/63acb44add614761fcc17ec2.html
聯(lián)系客服