配置数据库远程链接
创建用于远程链接的数据库用户
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)
最新评论
密码:blog.sirliu.com
本内容密码:blog.sirliu.com 最新整理的文章在这里喔:https://blog.sirliu.com/2018/11/shell_lian_xi_ti.html