当前位置: 代码迷 >> MySQL >> 设立MYSQL允许用IP访问
  详细解决方案

设立MYSQL允许用IP访问

热度:324   发布时间:2016-05-05 16:27:29.0
设置MYSQL允许用IP访问

mysql>use mysql;
mysql>update user set host = '%' ?where user ='root'; //or any other user need to remote connect.
mysql>flush privileges;
mysql>select 'host','user' from user where user='root';
mysql>quit

  相关解决方案