centos7.6 yum安装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.修改密码

密码强度,根据个人需要设置

【mysql】ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
出现问题：

CentOS安装完MySQL修改默认密码时出现了如下错误:
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

原因是因为密码设置的过于简单会报错,MySQL有密码设置的规范

查看MySQL完整的初始密码规则,登陆后执行以下命令
SHOW VARIABLES LIKE 'validate_password%';

密码的长度是由validate_password_length决定的,但是可以通过以下命令修改
set global validate_password_length=4;

validate_password_policy决定密码的验证策略,默认等级为MEDIUM(中等),可通过以下命令修改为LOW(低)
set global validate_password_policy=0;

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

其他指令

systemctl start mysqld  #启动
systemctl stop mysqld   #停止
systemctl status mysqld #状态

注意:

远程访问,要么关防火墙,要么开端口.