本次操作基于Ubuntu 22.04

1.进入mysql命令行执行：

mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '你的密码' WITH GRANT OPTION;
mysql>FLUSH PRIVILEGES;

2.然后修改mysql配置文件：vim /etc/mysql/mysql.conf.d/mysqld.cnf，找到并将bind-address = 127.0.0.1注释掉：

# bind-address           = 127.0.0.1

3.重启mysql服务，然后就可以远程登录了：

sudo service mysql restart