因官方下載太慢，所以使用國(guó)內(nèi)源

1.下載并安裝MySQL官方的 Yum Repository

//下載
[root@localhost ~]# wget http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
//安裝
[root@localhost ~]# yum -y install mysql57-community-release-el7-10.noarch.rpm

2.更換repo倉(cāng)庫(kù)里的連接開(kāi)源軟件鏡像站

image.png

[mysql-connectors-community]
name=MySQL Connectors Community
baseurl=https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql-connectors-community-el7-$basearch/
enabled=1
gpgcheck=1
gpgkey=https://repo.mysql.com/RPM-GPG-KEY-mysql

[mysql-tools-community]
name=MySQL Tools Community
baseurl=https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql-tools-community-el7-$basearch/
enabled=1
gpgcheck=1
gpgkey=https://repo.mysql.com/RPM-GPG-KEY-mysql

[mysql-5.6-community]
name=MySQL 5.6 Community Server
baseurl=https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql-5.6-community-el7-$basearch/
enabled=0
gpgcheck=1
gpgkey=https://repo.mysql.com/RPM-GPG-KEY-mysql

[mysql-5.7-community]
name=MySQL 5.7 Community Server
baseurl=https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql-5.7-community-el7-$basearch/
enabled=1
gpgcheck=1
gpgkey=https://repo.mysql.com/RPM-GPG-KEY-mysql

[mysql-8.0-community]
name=MySQL 8.0 Community Server
baseurl=https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql-8.0-community-el7-$basearch/
enabled=0//默認(rèn)安裝最新版本，因?yàn)樽约阂惭b5.7，所有把enabled=1改成enabled=0
gpgcheck=1
gpgkey=https://repo.mysql.com/RPM-GPG-KEY-mysql

3.安裝MySQL

 sudo yum install -y mysql-community-server

4.啟動(dòng)MySQL

sudo service mysqld start

5.查看MySQL服務(wù)狀態(tài)

sudo service mysqld status

image.png

6.初始化MySQL

查看初始化密碼：
sudo grep 'temporary password' /var/log/mysqld.log

image.png

使用初始密碼進(jìn)行登錄：
mysql -u root -p

image.png

初始化密碼
ALTER USER 'root'@'localhost' IDENTIFIED BY '初始化密碼';

7.設(shè)置MySQL密碼策略

查詢MySQL初始的密碼策略

 SHOW VARIABLES LIKE 'validate_password%'; 

image.png

修改密碼驗(yàn)證強(qiáng)度

set global validate_password_policy=LOW; 

修改密碼長(zhǎng)度

set global validate_password_length=6;

設(shè)置簡(jiǎn)單密碼

ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

8.設(shè)置MySQL遠(yuǎn)程連接，在sql里面設(shè)置

//這里設(shè)置登錄密碼和遠(yuǎn)程連接密碼都是123456
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
//刷新權(quán)限
FLUSH PRIVILEGES;

9.設(shè)置 MySQL開(kāi)機(jī)啟動(dòng)

systemctl enable mysqld

設(shè)置3306端口開(kāi)放

firewall-cmd --zone=public --add-port=3306/tcp --permanent
//重啟防火墻
firewall-cmd --reload
//驗(yàn)證3306是否開(kāi)放成功
firewall-cmd --zone=public --query-port=3306/tcp

10.遠(yuǎn)程連接

image.png