配置数据库远程链接

创建用于远程链接的数据库用户

GRANT 权限(可精确到表) ON 数据库名.表名 TO 用户@登录主机%表示所有电脑都可链接(还可指定IP) IDENTIFIED BY "用户密码";

GRANT ALL PRIVILEGES ON *.* TO 'UserName'@'%' IDENTIFIED BY 'Password' WITH GRANT OPTION;

刷新权限：FLUSH PRIVILEGES;

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

查看权限

mysql> select user,host from mysql.user;
+---------------+-----------+
| user          | host      |
+---------------+-----------+
| zabbix        | %         |
| mysql.session | localhost |
| mysql.sys     | localhost |
| root          | localhost |
+---------------+-----------+
4 rows in set (0.00 sec)