centos 配置mysql

linux root登录
su
******

启动mysql服务：systemctl  start mysqld.service
查看mysql服务：systemctl  status mysqld.service

mysql -uroot -p
P@ssw0rd

show databases;
use test;
show tables;
select * from stu_student;

退出mysql:quit

修改密码
mysql -uroot；
ALTER USER USER() IDENTIFIED BY 'P@ssw0rd';
flush privileges;

远程
select user,host from mysql.user;

CREATE USER 'sa'@'%' IDENTIFIED BY 'P@ssw0rd';
grant all on *.* to 'sa'@'%';
重启mysql服务：service mysqld restart

查看防火墙状态

firewall-cmd --state

开启防火墙: systemctl start firewalld.service
关闭防火墙: systemctl stop firewalld.service
禁用: systemctl disable firewalld.service

查看监听的端口: firewall-cmd --list-port
添加3306端口监听：firewall-cmd --zone=public --add-port=3306/tcp --permanent
刷新防火墙设置：firewall-cmd --reload