20231216 Ubuntu设置mysql远程访问

霍去病

# 创建mysql 远程账号
use mysql
grant all privileges on *.* to 'root'@'%' identified by 'root' with grant option;
flush privileges;

# 开启远程权限
sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
# bind-address 127.0.0.1

# 重启mysql服务
sudo service mysql restart