安装命令:
①sudo apt-get update
②sudo apt-get install mysql-server
③sudo apt install mysql-client
④sudo apt install libmysqlclient-dev
测试命令:
⑤systemctl status mysql.service
或者 sudo netstat -tap | grep mysql
修改配置文件:
⑥sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf
注释掉 bind-address = 127.0.0.1:
进入mysql文件设置:
⑦ mysql -u root -p
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '你的密码' WITH GRANT OPTION;(开启远程)
flush privileges; (刷新配置)
重启mysql服务:
⑧service mysql restart