navicat出现此问题：1044

今天用navicat连接数据库创建库时提示1044报错 无法创建库
找了下解决办法做记录！
首先查看user表的各个用户的权限信息
MariaDB [(none)]> SELECT host,user,password,Grant_priv,Super_priv FROM mysql.user;

+--------------+----------+-------------------------------------------+------------+------------+
| host         | user     | password                                  | Grant_priv | Super_priv |
+--------------+----------+-------------------------------------------+------------+------------+
| localhost    | root     | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 | Y          | Y          |
| 127.0.0.1    | root     | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 | Y          | Y          |
| ::1          | root     | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 | Y          | Y          |
| 192.168.3.98 | fzh      | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 | N          | N          |
| xxx.xxx.xx.x | username | *2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19 | N          | N          |
+--------------+----------+-------------------------------------------+------------+------------+

查看到fzh用户未授权

授权

MariaDB [(none)]> SELECT host,user,password,Grant_priv,Super_priv FROM mysql.user;
+--------------+----------+-------------------------------------------+------------+------------+
| host         | user     | password                                  | Grant_priv | Super_priv |
+--------------+----------+-------------------------------------------+------------+------------+
| localhost    | root     | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 | Y          | Y          |
| 127.0.0.1    | root     | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 | Y          | Y          |
| ::1          | root     | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 | Y          | Y          |
| 192.168.3.98 | fzh      | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 | Y          | Y          |
| xxx.xxx.xx.x | username | *2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19 | N          | N          |
+--------------+----------+-------------------------------------------+------------+------------+

刷新数据库

MariaDB [(none)]> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)