查看MariaDB RPM 依赖
rpm -qa | grep mariadb
yum remove postfix
rpm -e mariadb-libs
CentOs7 安装 Mysql5.7
1、下载mysql源安装包
wget http://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
2、安装mysql源
yum localinstall mysql57-community-release-el7-11.noarch.rpm
3、检查mysql源是否安装成功
yum repolist enabled | grep "mysql.*-community.*"
也可以修改 vim /etc/yum.repos.d/mysql-community.repo
源,改变默认安装的mysql版本。比如要安装5.6版本,将5.7源的enabled=1改成enabled=0。然后再将5.6源的enabled=0改成enabled=1即可。
执行安装的时候报错
Public key for mysql-community-client-5.7.39-1.el7.x86_64.rpm is not installed
Failing package is: mysql-community-client-5.7.39-1.el7.x86_64
导入KEY
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
yum install mysql-community-server -y
systemctl start mysqld
mysql安装完成之后,在/var/log/mysqld.log文件中给root生成了一个默认密码。通过下面的方式找到root默认密码,然后登录mysql进行修改:
grep 'temporary password' /var/log/mysqld.log
ps:如果没有返回,找不到root密码,解决方案:
# 1删除原来安装过的mysql残留的数据(这一步非常重要,问题就出在这)
rm -rf /var/lib/mysql
# 2重启mysqld服务
systemctl restart mysqld
# 3再去找临时密码
grep 'temporary password' /var/log/mysqld.log
修改密码策略
在/etc/my.cnf文件添加validate_password_policy配置,指定密码策略
# 0(LOW):验证 Length
# 1(MEDIUM):验证 Length; numeric, lowercase/uppercase, and special characters
# 2(STRONG):验证 Length; numeric, lowercase/uppercase, and special characters; dictionary file
validate_password_policy=0