alamlinux 安装mysql5.7（老方案）

alamlinux 安装mysql5.7

wget -qN http://repo.mysql.com/mysql57-community-release-el7-9.noarch.rpm

rpm -ivh mysql57-community-release-el7-9.noarch.rpm

dnf install mysql

yum repolist| grep mysql57

yum install mysql

wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.22-1.el7.x86_64.rpm-bundle.tar

tar xf mysql-5.7.22-1.el7.x86_64.rpm-bundle.tar

rpm -ivh mysql-community-common-5.7.22-1.el7.x86_64.rpm

rpm -ivh mysql-community-libs-5.7.22-1.el7.x86_64.rpm

rpm -ivh mysql-community-client-5.7.22-1.el7.x86_64.rpm （如果有报错，看下面解决方案）

rpm -ivh mysql-community-server-5.7.22-1.el7.x86_64.rpm

ll /run/mysqld/

mysql --version

如果遇到这个情况

出现警告：

warning: mysql-community-client-5.7.40-1.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 3a79bd29: NOKEY

原因：这是由于yum安装了旧版本的GPG keys造成的

解决办法：后面加上 --force --nodeps,如：

rpm -ivh mysql-community-client-5.7.40-1.el7.x86_64.rpm --force --nodeps

缺少依赖包：

error: Failed dependencies:

libncurses.so.5()(64bit) is needed by mysql-community-client-5.7.40-1.el7.x86_64

libtinfo.so.5()(64bit) is needed by mysql-community-client-5.7.40-1.el7.x86_64

解决缺少依赖包：

ln -s /usr/lib64/libncurses.so.6.1 /usr/lib64/libncurses.so.5

ln -s /usr/lib64/libtinfo.so.6.1 /usr/lib64/libtinfo.so.5

yum install ncurses-compat-libs

初始化操作

ALTER USER 'root'@'localhost' identified by 'yourpasswd'

如果报错

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

//设置密码强度检查

set global validate_password_policy=0;

//设置大写和小写字母最少个数

set global validate_password_mixed_case_count=0;

//设置数字最少个数

set global validate_password_number_count=0;

//设置特殊字符最少个数

set global validate_password_special_char_count=0;

//设置密码最小长度

set global validate_password_length=1;