指定远程IP使用root用户访问mysql数据库

登陆mysql数据库

mysql -u root -p
#输入密码

更改相关信息

# 选择user数据库
use user;
# 刷新权限
flush privileges;
# 查看user和host
select user, host from user;
# 如果存在用户root对应的host为%,则删除
DELETE FROM user WHERE host="%" and user="root"
# 授权用户
grant all privileges on *.* to 'root'@'182.92.4.200' IDENTIFIED BY "root账户密码" with grant option;

# 刷新权限
flush privileges;

修改mysql配置文件/etc/my.cnf

vim /etc/my.cnf

修改以下内容:

bind-address=mysql服务器IP
或者注释掉
# bind-address=mysql服务器IP
# 将skip-grant-tables注释掉
# skip-grant-tables