1、在mysql服务器端用“MySQL Command Line Client”登陆上MySQL服务器。
2、执行use mysql ,切换到mysql数据库,如下:
mysql> use mysql;
Database changed
3、执行select host, user, password from user; 如下:
mysql> select host, user, password from user;
+-------------+----- ---+-------------------------------------------------------------------+
| host | user | password |
+-------------+---------+-------------------------------------------------------------------+
| localhost | root | *A747E87038FE624A2A09CFC0079C242FC581BFBF |
| localhost | wklog | *DDFCBECE859C2D65DFAA129271291B5981B5B789 |
+-------------+---------+-------------------------------------------------------------------+
host字段表示登录的主机,其值可以用IP,也可用主机名,将host字段的值改为%就表示在任何客户端机器上能以user用户登录到mysql服务器.
4、执行update user set host = '%' where user='wklog';
在MySQL服务器端将MySQL重启后,用'wklog'用户连接正常~~~