CentOS7/8安装mysql5.7

本安装大部分同“安装 MariaDB 10.3数据库”

Installation

1. add repo

sudo yum install http://repo.mysql.com/mysql57-community-release-el7.rpm

2. install

import GPG:

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

CentOS7

sudo yum install mysql-community-server

CentOS8

Install after doing the following(disable default repo, config-manager, close gpgcheck):

sudo dnf install mysql-community-server

disable default repo

sudo dnf remove @mysql
sudo dnf module reset mysql
sudo dnf module disable mysql

config-manager

sudo dnf config-manager --disable mysql80-community
sudo dnf config-manager --enable mysql57-community

close gpgcheck

sudo vi /etc/yum.repos.d/mysql-community.repo

mysql-community.repo:

gpgcheck=0

3. init

  • start
sudo systemctl start mysqld.service
  • login
sudo grep "temporary password" /var/log/mysqld.log
mysql -uroot -p
  • change policy

  • change root password

mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('xbfirst80');

change policy

mysql> SHOW VARIABLES LIKE 'validate_password%';
mysql> SET GLOBAL validate_password_length = 6;
mysql> set global validate_password_policy=0;

Reference