解决mysql远程连接报10038的错误
2016-09-27 本文已影响146人
景岳
解决方案如下:
-
授权
mysql> grant all privileges on *.* to 'root'@'%' identified by 'youpassword' with grant option; mysql> flush privileges; //刷新
-
修改
/etc/mysql/my.conf
找到`bind-address = 127.0.0.1`这一行 改为`bind-address = 0.0.0.0`即可