mysql允许root远程登录

MySQLMySQL 默认不允许远程以root进行登陆

进入mysql后

mysql>select host, user from user;

+--------------------+------+
| host               | user |
+--------------------+------+
| 127.0.0.1          | root |
| ::1                | root |
| localhost          |      |
| localhost          | root |
| vm\_144\_7\_centos |      |
| vm\_144\_7\_centos | root |
+--------------------+------+

mysql>use mysql;

mysql>update user set host = ‘%’ where user = ‘root’;

mysql>select host, user from user;

+--------------------+------+
| host               | user |
+--------------------+------+
| %                  | root |
| 127.0.0.1          | root |
| ::1                | root |
| localhost          |      |
| vm\_144\_7\_centos |      |
| vm\_144\_7\_centos | root |
+--------------------+------+
如果发现下载不了或者地址失效,请联系客服QQ: 2323178881
找资料 » mysql允许root远程登录

提供最优质的资源集合

立即查看 了解详情