官网地址 https://dev.mysql.com/downloads/repo/yum/
wget https://repo.mysql.com//mysql80-community-release-el7-3.noarch.rpmyum localinstall mysql80-community-release-el7-3.noarch.rpmyum repolist enabled | grep "mysql.*-community.*"
选择指定版本。
vim /etc/yum.repos.d/mysql-community.repo
把5.7的enabled设置成1并且把8.0的设置成0
# Enable to use MySQL 5.7[mysql57-community]name=MySQL 5.7 Community Serverbaseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/7/$basearch/enabled=1gpgcheck=1gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql[mysql80-community]name=MySQL 8.0 Community Serverbaseurl=http://repo.mysql.com/yum/mysql-8.0-community/el/7/$basearch/enabled=0gpgcheck=1gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
yum install -y mysql-community-server# 启动MySQLsystemctl start mysqldsystemctl status mysqld# 设置开启重启systemctl enable mysqldsystemctl daemon-reload
初次安装 root密码位置
grep 'temporary password' /var/log/mysqld.logshell> mysql -uroot -pmysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'root';或者mysql> set password for 'root'@'localhost'=password('root');
如果不能设置简单密码,开发环境可以调整如下参数
mysql> set global validate_password_policy=0;# 5.7密码长度不能小于4mysql> set global validate_password_length=4;
