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

原创 2016年08月30日 03:06:37

问题描述: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' 


相关文章推荐

Mariadb-Host '192.168.*.*' is not allowed to connect to this MariaDB server"的解决方法

GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.100.%' IDENTIFIED BY 'my-new-password' WITH GRANT OPT...

Host '*' is not allowed to connect to this MariaDB server

MYSQL权限问题 原因:安装MySQL时没有勾选“Enable root access from remote machines” 如何开启MySQL的远程帐号-1)首先以 root...

Delphi7高级应用开发随书源码

  • 2003年04月30日 00:00
  • 676KB
  • 下载

解决报错:错误1130- Host xxx is not allowed to connect to this MariaDb server

在云服务器上面搭建了MariaDb(MariaDB是MySQL源代码的一个分支),但是远程链接不上。  首先,你要确保服务器安全组3306端口已经开放。  在确保端口开放的情况下,如果出现错误代码11...

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

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

SQL Error (1130): Host '192.168.1.126' is not allowed to connect to this MySQL server

通过HeidiSQL连接MYSQL数据库报错:  SQL Error (1130): Host '192.168.1.126' is not allowed to connect to this M...
  • rgb_rgb
  • rgb_rgb
  • 2014年08月20日 00:07
  • 8317

MySQL:远程访问权限,is not allowed to connect to this MySQL server

一、连接数据库错误 1.1 错误现象         mysql_real_connect() error: Host '192.168.175.1' is not allowed to connec...

服务器连接错误Host 'XXX' is not allowed to connect to this MySQL server如何解决

      Host 'Local' is not allowed to connect to this MySQL server 典型的远程权限问题。问题症结是MySQL 没有开放远程登录的权限。 ...

is not allowed to connect to this MySQL server解决办法

ERROR 1130: Host ’192.168.1.3′ is not allowed to connect to this MySQL server这是告诉你没有权限连接指定IP的主机,下面我们...

解决Navicat 报错:1130-host ... is not allowed to connect to this MySql server,MySQL不允许从远程访问的方法

http://blog.csdn.net/lhh1002/article/details/6131733
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:Navicat 连接mysql失败: Host '*' is not allowed to connect to this MariaDB server
举报原因:
原因补充:

(最多只允许输入30个字)