ubuntu20安装mysql8.0允许远程访问

​​​​​​ubuntu20安装mysql8.0允许远程访问_sunrj_niu的博客-CSDN博客_ubuntu安装mysql8.0

1、本地登录mysql

#本地登录
mysql -uroot -p

mysql> use mysql;
mysql> select host, user, authentication_string, plugin from user;

mysql> create user 'root'@'%' identified by '你自己的mysql密码';
mysql> grant all privileges on *.* to 'root'@'%';
mysql> flush privileges;

2、修改conf

cd  /etc/mysql/mysql.conf.d
vim mysqld.cnf
#将bind-address            = 127.0.0.1 修改为 bind-address            = 0.0.0.0

3、重启服务

systemctl  restart mysql