连接mysql或mariaDB报错：is not allowed to connect to this MariaDB server

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;

重新加载权限表后才会生效，才可以远程连接数据库