0.先进入mysql,查看所有数据库show databases;
1.选择mysql数据库,use mysql;然后执行如下操作:
2.允许任何IP远程连接
update user set Host='%' where User='root';
3.设置密码规则
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root';
4.设置远程访问--首先进入mysql
grant all privileges on *.* to 'root'@'%' with grant option;
5.进行指令刷新
flush privileges;
6.退出mysql
exit
7.注释bind-address=127.0.0.1
打开文件
sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf
设置成如下内容,即将其注释掉。要求会用vi或vim编辑文件和保存
#bind-address=127.0.0.1
mysqlx-bind-address = 127.0.0.1