MySQL配置连接
1. 安装
sudo apt install mysql-server
2. 登录数据库
mysql -u root -p
3. 开启root用户访问权限
mysql> use mysql;
mysql> update user set host='%' where user='root';
mysql> flush privileges;
mysql> grant all privileges on *.* to 'root'@'%';
mysql> flush privileges;
mysql> quit
4. 修改my.conf中的ip绑定
sudo vim /etc/mysql/mysql.conf.d/mysqld.conf
将bind-address = 127.0.0.1修改为bind-address = 0.0.0.0
5. 重启服务
sudo service mysql restart
6. 服务命令
启动服务:sudo service mysql start
停止服务:sudo service mysql stop
重启服务:sudo service mysql restart