查看数据库用户zhuohua@'%'的权限:(可以管理所有的库)
MariaDB [(none)]> show grants for zhuohua@'%';
+-------------------------------------------------------------------------------
----------------------------------+
| Grants for zhuohua@%
|
+-------------------------------------------------------------------------------
----------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'zhuohua'@'%' IDENTIFIED BY PASSWORD '*23AE809DDACAF96AF0FD78ED04B6A265E05AA257' |
+-------------------------------------------------------------------------------
----------------------------------+
1 row in set (0.00 sec)
要想远程客户端可以直接访问数据库,记得在防火墙手动添加入站规则,打开TCP 3306 端口: