Navicat 连接 MySQL 失败 : 1130 - Host xxx is not allowed to connect to this MySQL server
程序员文章站
2022-07-01 15:15:51
...
解决Navicat 报错: 1130
1、报错信息
1130 - Host xxx is not allowed to connect to this MySQL server
截图:
2、报错原因
报错原因:
是mysql未开启mysql远程访问权限导致。
3、解决办法
授予远程登录权限:
(1)、改表法:
mysql -uroot -ppassword
mysql>use mysql;
mysql>update user set host = '%' where user = 'root';
(2)、授权法:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
FLUSH PRIVILEGES;
再次连接
打开数据库:
推荐阅读
-
Mysql远程连接 Host * is not allowed to connect to this MySQL server
-
MySQL 1130 - Host 127.0.0.1 is not allowed to connect to this MySQL server
-
Navicat 连接 MySQL 失败 : 1130 - Host xxx is not allowed to connect to this MySQL server
-
MYSQL Error 1130:Host '计算机名' is not allowed to connect to this MySQL server
-
转:mysql远程连接 Host * is not allowed to connect to this MySQL server
-
关于对连接数据库时出现1130-host “**” is not allowed to connect to this MySql/mariadb server 的错误解决方法
-
mysql连接提示"Host 'XXX' is not allowed to connect to this MySql server"
-
Mysql报错:1130-host ... is not allowed to connect to this MySql server如何处理
-
Mysql报错:1130-host ... is not allowed to connect to this MySql server如何处理
-
Mysql远程连接 Host * is not allowed to connect to this MySQL server