mysql开启远程访问

1 2 3 4 5 6 7 8 9 10 11 12

#1.在连接服务器后,操作mysql系统数据库 mysql -u root -p use mysql; GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'pwd' WITH GRANT OPTION; FLUSH PRIVILEGES; quit nano /etc/mysql/mysql.conf.d/mysqld.cnf #2.注释掉 bind-address = 127.0.0.1 #3.重启mysql service mysql restart #重启 sudo service ssh restart