解决mysql远程连接报10038的错误

2016-09-27  本文已影响146人  景岳

解决方案如下:

  1. 授权

    mysql> grant all privileges on *.*  to  'root'@'%' identified by 'youpassword'  with grant option;
    
    mysql> flush privileges;      //刷新
    
  2. 修改/etc/mysql/my.conf

     找到`bind-address = 127.0.0.1`这一行
     改为`bind-address = 0.0.0.0`即可
上一篇 下一篇

猜你喜欢

热点阅读