Centos离线安装mysql5.7

1、卸载MariaDB

由于centOS7中默认安装了MariaDB,需要先进行卸载

rpm -qa | grep -i mariadb
rpm -e --nodeps mariadb-libs-5.5.64-1.el7.x86_64

 2、卸载mysql

查询下本机mysql是否卸载干净

rpm -qa | grep mysql

3、 下载MySql的相关rpm包

在https://downloads.mysql.com/archives/community/ ，产品版本选择5.7.42 ，操作系统选择Red Hat Enterprise Linux 7/Oracle Linux 7 ，把OS的版本选择为all ，直接下载mysql-5.7.42-1.el7.x86_64.rpm-bundle.tar ，所有的rpm包都在里面。

如果觉得下载太慢，文件已上传到网盘，可以去我网盘下载。

FuZai's分享

来源：123网盘 | 提取码：xf66

立即下载

4. 解压mysql-5.7.42-1.el7.x86_64.rpm-bundle.tar

tar zxvf mysql-5.7.42-1.el7.x86_64.rpm-bundle.tar

5、安装rpm包

rpm -ivh mysql-community-common-5.7.43-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.43-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-compat-5.7.43-1.el7.x86_64.rpm
rpm -ivh mysql-community-devel-5.7.43-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.43-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.43-1.el7.x86_64.rpm

6、数据库初始化

对mysql数据库的初始化和相关配置命令，包含自启动：

mysqld --initialize
chown mysql:mysql /var/lib/mysql -R
systemctl start mysqld.service
systemctl enable mysqld

7、查看数据库的密码命令

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

 8、连接数据库

mysql -u root -p

9、修改密码

mysql>ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'admin@123';

10、开启远程

mysql>update mysql.user set host='%' where user='root';

11、进入mysql命令行模式，查看用户是否修改成功

mysql >select user,host from mysql.user;

systemctl start mysqld.service
systemctl stop mysqld.service
systemctl restart mysqld.service

firewall-cmd --zone=public --add-port=3306/tcp --permanent

firewall-cmd --reload