Navicat 远程连接数据库

在主机下通过Navicat连接服务器MySql的时候，提示
1130 Host '192.168.33.200' is not allowed to connect to this MySql server
这是授权问题：没有给远程登录用户添加所有机器都能访问的权限

[vagrant@test ~]$ mysql -uroot -p
MariaDB [(none)]> use mysql;
MariaDB [mysql]> select host,user,password from user;
+-----------+------+-------------------------------------------+
| host      | user | password                                  |
+-----------+------+-------------------------------------------+
| localhost | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
| test      | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
| 127.0.0.1 | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
| ::1       | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
+-----------+------+-------------------------------------------+
MariaDB [mysql]> grant all privileges  on *.* to root@'%' identified by "root";
MariaDB [mysql]> select host,user,password from user;
+-----------+------+-------------------------------------------+
| host      | user | password                                  |
+-----------+------+-------------------------------------------+
|  %        | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
| test      | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
| 127.0.0.1 | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
| ::1       | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
| %         | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
+-----------+------+-------------------------------------------+

这样在远端就可以通过root用户访问Mysql