Ubuntu mysql开启远程连接

使用root用户登录mysql

mysql -u root -p

新增一个用户

use mysql;
CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';

给新用户添加权限

GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
flush privileges;
quit

修改mysql配置文件

sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf

找到bind-address = 127.0.0.1
修改为 bind-address = 0.0.0.0

:wq

重启mysql

service mysql restart

开放3306端口
服务器需要配置安全组规则
有防火墙需要开放3306

sudo ufw allow 3306