- 端口未开放
用sudo ufw allow mysql
开放3306端口 - 配置问题
把/etc/mysql/mysql.conf.d/mysqld.cnf
的bind-address = 127.0.0.1
注释掉 - user未设置远程访问
grant all privileges on *.* to 用户名@'%' identified by '密码';
Ubuntu 18.04 msyql远程连接失败原因
最新推荐文章于 2024-03-04 05:40:44 发布
sudo ufw allow mysql
开放3306端口/etc/mysql/mysql.conf.d/mysqld.cnf
的bind-address = 127.0.0.1
注释掉grant all privileges on *.* to 用户名@'%' identified by '密码';