解决mysql不能远程连接
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 |
[root@test html]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 55 Server version: 5.1.69 Source distribution Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> use mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> grant all privileges on *.* to root@'%' identified by "密码"; 授权root用户远程登录 Query OK, 0 rows affected (0.00 sec) mysql> select host,user,password from user; +-----------+------+----------+ | host | user | password | +-----------+------+----------+ | localhost | root | | | test.cn | root | | | 127.0.0.1 | root | | | localhost | | | | test.cn | | | | % | root | | +-----------+------+----------+ 6 rows in set (0.00 sec) |
2013年11月21日, PM 02:16:14
版权声明:
作者:龙魂
链接:https://blog.wlzs.cn/%e8%a7%a3%e5%86%b3mysql%e4%b8%8d%e8%83%bd%e8%bf%9c%e7%a8%8b%e8%bf%9e%e6%8e%a5/
来源:学海无涯
文章版权归作者所有,未经允许请勿转载。
THE END
0
二维码
海报
解决mysql不能远程连接
Shell
[root@test html]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 55
Se……

共有 0 条评论