Mysql远程连接问题

show databases; # 显示所有的数据库
use mysql; # 随便选一个库use
SELECT user FROM user; # 查看用户
SELECT user , host, account_locked, password_expired FROM user ; # 查看权限信息
# 查看当前远程连接的权限
select User,authentication_string,Host from user;
# 创建用户远程访问权限
create user root@'%' identified by '123456';
# 允许指定主机(IP地址)访问权限
grant all privileges on test.* to '用户名'@'ip地址' identified by '密码';
# 无法创建请删除重新试一遍
drop user root@'ip地址';
# 赋予用户操作的全部权限
grant all privileges on *.* to root@'%';
# 刷新指令
flush privileges;

完整逻辑:

centos7.6 yum 安装mysql_centos7.6 yum安装mysql_tenc1239的博客-CSDN博客