1.报错信息:Host ‘192.168.3.91’ is not allowed to connect to this MariaDB server
2.报错原因:因为没有远程连接数据库的权限
一般为新创建数据库或新创建的用户没有远程连接数据库的权限,需要进行授权
# mysql -u root -p
# use mysql;
# update user set host = '%' where user ='root';
# flush privileges;
# quit;
1、在命令行连接数据库
[root@bogon /]# mysql -uroot -p
Enter password:
2、查看数据库
MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
| zabbix |
+--------------------+
3、进入mysql数据库
MariaDB [(none)]> use mysql;
4、查看user表中root用户或需要使用远程连接的用户信息(我这里已经操作过了,所以显示root的host是%)
MariaDB [mysql]> select host,user from user;
+-----------+--------+
| host | user |
+-----------+--------+
| % | root |
| 127.0.0.1 | root |
| ::1 | root |
| bogon | root |
| localhost | zabbix |
+-----------+--------+
5、修改host
update user set host = '%' where user ='root';
6、重新加载权限表
flush privileges;
重新加载权限表后才会生效,才可以远程连接数据库