连接数据库 出现1130错误 Navicat For MySQL

xiaoxiao2021-02-28  17

错误代码是1130,ERROR 1130: Host xxx.xxx.xxx.xxx is not allowed to connect to this MySQL server 是无法给远程连接的用户权限问题

1,在服务器上打开CMD,然后数据库密码,成功后

2, 给用户授权 (我用的用户是root 密码123456 )

示例: Sql代码 GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;

复制这些代码运行

GRANT ALL PRIVILEGES ON *.* TO '数据库用户名'@'%' IDENTIFIED BY '数据库密码' WITH GRANT OPTION;

mysql flush privileges;

转载请注明原文地址: https://www.6miu.com/read-249995.html

最新回复(0)