linux安装MySQL

1.先删除Linux自带的MariaDB

yum -y remove maria*

2.下载仓库文件

wget https://dev.mysql.com/get/mysql80-community-release-el7-5.noarch.rpmhttps://dev.mysql.com/get/mysql80-community-release-el7-5.noarch.rpm3.安装

yum localinstall mysql80-community-release-el7-5.noarch.rpm -y

4.验证仓库

yum repolist enable grep mysql

5.安装MySQL

yum -y install mysql-community-server

6.启动

systemctl start mysqld

systemctl enable mysqld

systemctl status mysqld

7.查看初始密码,复制

cat /var/log/mysqld.log|grep password

8.登录MySQL,提示修改密码

mysql -uroot -p

9.修改密码

alter user 'root'@'localhost' identified by '强密码';

10.修改密码强度限制

set global validate_password.policy=0; # 0数字 1数字字母符号 2数字字母特殊符号文件

set global validate_password.length=6; #密码长度,至少为4

11.解除远程访问

use mysql;

update user set host='%' where user='root';

flush privileges;

12查看字符编码,为utf8mb4

status

13.打开防火墙

firewall-cmd --zone=public --add-port=3306/tcp --permanent

firewall-cmd --reload