mysql 8.0 远程连接问题

mysql用户

use mysql;

查看user表信息

select user,host from user;

查看登录用户名对应的host是否为“%”

否则修改为%

update user set host='%' where user='root' and host='localhost';

 

如果提示密码错误问题

修改密码加密模式

ALTER USER 'root'@'%' IDENTIFIED BY 'mysql  root密码' PASSWORD EXPIRE NEVER;

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '新 root密码';

修改密码方式

update user set authentication_string='' where user='root';

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你的密码';

FLUSH PRIVILEGES;

 

防火墙开启端口

1、关闭firewall：
systemctl stop firewalld.service
systemctl disable firewalld.service
systemctl mask firewalld.service

2、安装iptables防火墙
yum install iptables-services -y

3.启动设置防火墙

# systemctl enable iptables
# systemctl start iptables

4.查看防火墙状态

systemctl status iptables

vim   /etc/sysconfig/iptables

-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT

systemctl restart iptables.service #重启防火墙使配置生效

systemctl enable iptables.service #设置防火墙开机启动