解决方案如下:
-
授权
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`即可
授权
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`即可
本文标题:解决mysql远程连接报10038的错误
本文链接:https://www.haomeiwen.com/subject/kipcyttx.html
网友评论