Mysql远程登录报错:Host '192.168.1.3' is not allowed to connect to this MySQL server

你要访问的MySQL服务器设置了访问权限:如果那个服务器是你自己搭建的解决办法如下,但如果不是你的请管理员帮你添加权限

解决办法1:

# 1. 改表# 登录数据库:mysql -u root -pmysql>use mysql;mysql>update user set host = % where user = root;mysql>FLUSH PRIVILEGES;
2. 授权法。(1)例如,你想myuser使用mypassword从任何主机连接到mysql服务器的话。第一步:root用户登录;mysql>mysql -u root -p rootpassword;第二步:赋予权限;mysql>GRANT ALL PRIVILEGES ON *.* TO root@% IDENTIFIED BY mypassword WITH GRANT OPTION;第三步:mysql>FLUSH PRIVILEGES;(2)如果你想允许用户myuser从ip为192.168.1.3的主机连接到mysql服务器,并使用mypassword作为密码mysql>GRANT ALL PRIVILEGES ON *.* TO root@192.168.1.3 IDENTIFIED BY mypassword WITH GRANT OPTION;mysql>FLUSH PRIVILEGES;(3)如果你想允许用户myuser从ip为192.168.1.3的主机连接到mysql服务器的dk数据库,并使用mypassword作为密码mysql>GRANT ALL PRIVILEGES ON dk.* TO root@192.168.1.3 IDENTIFIED BY mypassword WITH GRANT OPTION;mysql>FLUSH PRIVILEGES;

相关文章