yum安装指定版本mysql5.7

yum 安装指定版本mysql5.7

• 安装依赖环境

# yum install -y yum-utils  wget

• 下载仓库包

# wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm

• 安装仓库包

# rpm -ivh mysql80-community-release-el7-3.noarch.rpm  --no-check-certificate
# 解决报错如，Check that the correct key URLs are configured for this repository.
# rpm --import http://repo.mysql.com/RPM-GPG-KEY-mysql-2022  

• 更新 yum仓

# yum makecache

• 查看可用版本

# yum repolist all | grep mysql

默认开启最新版本enabled，需要改成需要的版本

• 修改为需要的版本，即禁用yum存储库中mysql不需要的版本和开启需要的版本

# yum-config-manager --disable mysql80-community
# yum-config-manager --enable mysql57-community

• 查看需要的版本是否enabled

# yum repolist all | grep mysql

• 开始安装mysql

# yum install mysql-community-server -y

• 启动mysql

# systemctl start mysqld

• 5.7版本mysql第一次启动自动生成临时密码，需要修改后才能正常使用

## 查看临时密码
# grep 'temporary password' /var/log/mysqld.log

## 登录mysql
# mysql -uroot -p

## 修改密码
# mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyDB_2021';
mysql>  ALTER USER USER()   identified by 'MyDB_2021';
Query OK, 0 rows affected (0.00 sec)

mysql免密登录

• 无密码登录

修改my.cnf，找到[mysqld]，在下面加上skip-grant-tables或者–skip-grant-tables，重启mysql即可无密码登录

修改root密码

通过 root 免密 登录后，执行修改root密码操作，再取消 免密登录。

1、免密登录

修改my.cnf，找到[mysqld]，在下面加上skip-grant-tables或者–skip-grant-tables，重启mysql即可无密码登录

[root@vm13 ~]# cat /etc/my.cnf
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html

[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-grant-tables 

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[root@vm13 ~]#

# systemctl start mysqld

输入命令 update mysql.user set authentication_string=password(‘root2022’) where user=‘root’ ; 设置新密码。

注意：MySQL 5.7 版本中的 user 表里已经去掉了 password 字段，改为了 authentication_string。

刷新权限（必须步骤），输入flush privileges;命令。

将 上述修改的配置 注释掉，还原，再次重启生效即可

---- win 修改如下：
http://c.biancheng.net/view/7156.html