480
个编辑
更改
→mysql数据库用户远程授权
=mysql数据库用户远程授权=
# 查看firewall服务状态是否开放3306;
# 查看远程用户权限,如root:<pre>select host,user, select_priv,insert_priv,drop_priv from mysql user;</pre>
# 开放远程用户权限,如root:<pre>grant all privileges to 'root'@'%' indentified by 'password';</pre>
# flush privileges;
# systemctl restart mysqld
# eof