1,sqlyog客户端,用root用户远程链接mysql时,提示“访问被拒绝”,在网上搜索了一下原因。
原来是mysql没有授权其远程链接,所以你只能在客户端里面链接。
怎么解决呢?
原表数据
mysql> use mysql
mysql> select Host,User,Password from user ;
+---------------+---------+-------------------------------------------+
| Host | User | Password |
+---------------+---------+-------------------------------------------+
| localhost | root | *DEA65ABECC50A1FEBD9C0D0D9045E0DDB312F38F |
| www | root | *DEA65ABECC50A1FEBD9C0D0D9045E0DDB312F38F |
| 127.0.0.1 | root | *DEA65ABECC50A1FEBD9C0D0D9045E0DDB312F38F |
| ::1 | root | *DEA65ABECC50A1FEBD9C0D0D9045E0DDB312F38F |
创建一个新用户
格式:grant 权限 on 数据库名.表名 to 用户@登录主机 identified by "用户密码";
grant select,update,insert,delete on *.* to
[email protected] identified by "komiles1234";
执行完上面语句后,再执行
mysql> select Host,User,Password from user ;
+---------------+---------+-------------------------------------------+
| Host | User | Password |
+---------------+---------+-------------------------------------------+
| localhost | root | *DEA65ABECC50A1FEBD9C0D0D9045E0DDB312F38F |
| www | root | *DEA65ABECC50A1FEBD9C0D0D9045E0DDB312F38F |
| 127.0.0.1 | root | *DEA65ABECC50A1FEBD9C0D0D9045E0DDB312F38F |
| ::1 | root | *DEA65ABECC50A1FEBD9C0D0D9045E0DDB312F38F |
| 123.4.56.89 | komiles | *50663F1ECEAB844897BC272EC1AE7E83F442F649 |
+---------------+---------+-------------------------------------------+
此时,就可以用你刚才创建的用户进行远程访问了。