CentOS安装MySQL

安装wget软件
yum -y install wget

下载MySQL的RPM文件
wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm

安装MySQL的RPM文件
rpm -ivh mysql57-community-release-el7-11.noarch.rpm

安装MySQL软件
yum -y install mysql-server

启动MySQL软件
service mysqld start
systemctl start mysqld.service

查询MySQL状态
service mysqld status
systemctl status mysqld.service

查看密码
grep 'temporary password' /var/log/mysqld.log

登录
mysql -uroot -p

修改密码
set global validate_password_policy=0;
set global validate_password_length=1;
ALTER USER 'root'@'localhost' IDENTIFIED BY 'liunancun';

开启远程访问权限
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'liunancun' WITH GRANT OPTION;
flush privileges;
或者
use mysql;
update user set host = '%' where user = 'root';
select host, user from user;

查看防火墙状态
firewall-cmd --state
停用防火墙
systemctl stop firewalld.service
禁止防火墙开启启动
systemctl disable firewalld.service