CentOS7.5使用RPM包安装MySQL5.7.22和MySQL8

　　参考：https://blog.csdn.net/sevenkoala/article/details/76163853

 

　　1，安装环境查看

 

　　2，下载安装rpm包

　　下载地址：https://downloads.mysql.com/archives/community/

　　https://downloads.mysql.com/archives/get/file/mysql-5.7.22-1.el7.x86_64.rpm-bundle.tar

 

　　3，安装

　　解压

?

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

　　解压后如下rpm安装包

　　清理mysql-libs

?

1	yum remove mysql-libs

　　安装，安装顺序为common-libs-client-server

?

1 2 3 4

rpm -vih mysql-community-common-5.7.22-1.el7.x86_64.rpm rpm -vih mysql-community-libs-5.7.22-1.el7.x86_64.rpm rpm -vih mysql-community-client-5.7.22-1.el7.x86_64.rpm rpm -vih mysql-community-server-5.7.22-1.el7.x86_64.rpm

　　启动

?

1 2 3

systemctl start mysqld systemctl status mysqld systemctl enable mysqld

　　查看自动生成的密码

?

1	cat /var/log/mysqld.log | grep password

　　登录

?

1	mysql -uroot -p'<>fd!vher73Y'

　　PS：如果密码有特殊字符需要用引号引起来

　　修改密码

?

1	set password=password('password');

　　2024-08-02补充开始

　　如果以上命令不生效使用以下命令修改密码,需要满足复杂度需求

?

1	alter user 'root'@'localhost' identified by 'Passw0$R';

　　2024-08-02补充结束

　　PS:密码需满足复杂性要求否则修改失败

　　关于密码复杂度导致修改密码失败解决办法参考

　　https://blog.csdn.net/hello_world_qwp/article/details/79551789#

 

　　2024-01-23补充安装MySQL8

　　如果有mariadb则先卸载否则下面安装会报错

?

1	yum remove mariadb-libs

　　安装顺序

?

1 2 3 4 5 6 7 8 9 10 11 12 13

rpm -ivh mysql-community-common-8.0.36-1.el7.x86_64.rpm rpm -ivh mysql-community-libs-8.0.36-1.el7.x86_64.rpm rpm -ivh mysql-community-client-8.0.36-1.el7.x86_64.rpm rpm -ivh mysql-community-client-plugins-8.0.36-1.el7.x86_64.rpm rpm -ivh mysql-community-libs-8.0.36-1.el7.x86_64.rpm rpm -ivh mysql-community-client-8.0.36-1.el7.x86_64.rpm rpm -ivh mysql-community-server-8.0.36-1.el7.x86_64.rpm rpm -ivh mysql-community-icu-data-files-8.0.36-1.el7.x86_64.rpm yum -y install net-tools rpm -ivh mysql-community-server-8.0.36-1.el7.x86_64.rpm systemctl start mysqld systemctl enable mysqld systemctl status mysqld