Navicat 连接mysql失败: Host '*' is not allowed to connect to this MariaDB server

问题描述:Navicat 为管理方便,连接Linux 中mysql失败,如下如下错误:Host '*' is not allowed to connect to this MariaDB server

解决方案:

//允许用户testuser从ip为222.129.1.1的主机连接到mysql服务器,并使用testpassword作为密码
MariaDB [(none)]> grant all privileges on *.* to 'testuser'@'222.129.1.1' identified by 'testpassword' with grant option;  
(若是允许所有ip:GRANT ALL PRIVILEGES ON *.* TO ‘testuser’@'%’ IDENTIFIED BY ‘testpassword’ WITH GRANT OPTION;)
MariaDB [(none)]> flush privileges;   //刷新权限缓存
MariaDB [(none)]> show privileges;
MariaDB [(none)]> show grants for  'testuser'@'222.129.1.1' 


阅读更多
个人分类: 开发
想对作者说点什么? 我来说一句

没有更多推荐了,返回首页

不良信息举报

Navicat 连接mysql失败: Host '*' is not allowed to connect to this MariaDB server

最多只允许输入30个字

加入CSDN,享受更精准的内容推荐,与500万程序员共同成长!
关闭
关闭