centos7 安装 mysql5.7

安装mysql5.7详细步骤

1.下载yum源

wget 'https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm'

 

2.安装yum源

rpm -Uvh mysql57-community-release-el7-11.noarch.rpm

 

3.查看有哪些版本的Mysql

yum repolist all | grep mysql

 

4.安装

yum install -y mysql-community-server

如果报错: 重新导入证书，然后重新安装

rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022

5.启动

systemctl start mysqld

6.查看初始密码

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

 

7.登录

mysql -u root -p 输入上面的密码

8.修改密码

SET PASSWORD = PASSWORD('123456');

 

9.允许远程登录

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;

10.刷新

flush privileges;

 

11.配置mysql

vim /etc/my.cnf

# 在[mysqld]下面添加，不需要分号
[mysqld]
character-set-server=utf8
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
# 设置时区
default-time_zone = '+8:00'

# 新建数据库添加的配置信息
lower_case_table_names=1
default-storage-engine=INNODB
character-set-server=utf8
collation-server=utf8_general_ci
max_connections=10000
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

 

12.配置好编码和时区之后重启数据库

systemctl restart mysqld

13. 设置开机自启

systemctl enable mysqld
systemctl daemon-reload

13. mysql8数据迁移到mysql5需修改sql脚本

将SQL文件中的以下内容批量替换

utf8mb4_0900_ai_ci    换成   utf8_general_ci

utf8mb4    换成  utf8

其他可能的高版本特有排序规则（如uft8_croatian_ci）也需替换为utf8_general_ci