安装
sudo apt install mysql-server -y
查看
sudo systemctl status mysql
安全
设置密码以及强度,后续输入y回答所有问题即可
sudo mysql_secure_installation
配置
修改监听地址,以便远程访问
sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
由 bind-address = 127.0.0.1
改为 bind-address = 0.0.0.0
允许远程访问的root用户访问所有权限,并且刷新权限表
grant 权限 privileges on 数据库名.表名 to '用户名'@'IP地址' identified by '密码' with grant option;
grant all privileges on *.* to 'root'@'%' identified by '你的密码' with grant option;
flush privileges;
重启
service mysql restart
查看防火墙
systemctl status firewalld
查看端口3306
firewall-cmd --zone=public --query-port=3306/tcp
开启3306端口
firewall-cmd --zone=public --add-port=3306/tcp --permanent
重启防火墙
firewall-cmd --reload
查看3306
firewall-cmd --zone=public --query-port=3306/tcp