Centos安装Mysql图文配置详解

1. 安装镜像源

• Centos7

# MySQL 5.7
yum -y install http://repo.mysql.com/mysql57-community-release-el7.rpm

# MySQL 8.0
yum -y install http://repo.mysql.com/mysql80-community-release-el7.rpm

• Centos8

# mysql8
yum -y install http://repo.mysql.com/mysql80-community-release-el8.rpm

2. 查看已安装源

ll /etc/yum.repos.d/

搜索Mysql版本

# 其中 --nogpgcheck 是不验证gpg签名。根据需要选择
yum --showduplicates list mysql-community-server --nogpgcheck

4 安装

4.1 安装指定版本

yum -y install mysql-community-server-5.7.25-1.el7 --nogpgcheck

4.2 安装最新版本

yum -y install mysql-community-server --nogpgcheck

5. 启动

systemctl start mysqld

#设置开机自启动
systemctl enable mysqld

6. 查看历史密码

grep 'temporary password' /var/log/mysqld.log

7. 连接

mysql -u root -p

8. 修改密码强度

8.1 mysql5.7

set global validate_password_policy=0;
set global validate_password_mixed_case_count=0;
set global validate_password_number_count=0;
set global validate_password_special_char_count=0;
set global validate_password_length=4;

8.2 mysql8.0

set global validate_password.policy=0;
set global validate_password.mixed_case_count=0;
set global validate_password.number_count=0;
set global validate_password.special_char_count=0;
set global validate_password.length=4;

9. 修改密码

# 首次登录需要修改密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';

10. 授权远程连接

RENAME USER `root`@`localhost` TO `root`@`%`;
#刷新权限
flush privileges;

开放端口

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