Centos7安装Mysql5.7.38详细教程

一、检测是否安装mysql

[root@VM-0-8-centos]# rpm -qa | grep mysql

二、检测是否安装Mariadb

[root@VM-0-8-centos]# rpm -qa | grep mariadb
mariadb-libs-5.5.68-1.el7.x86_64

三、删除mysql

[root@VM-0-8-centos]# yum remove mysql mysql-server mysql-libs mysql-server

四、找出所有与mysql相关内容

[root@VM-0-8-centos]# find / -name mysql
/etc/selinux/targeted/active/modules/100/mysql
/usr/lib64/mysql

五、删掉mysql相关内容

[root@VM-0-8-centos]# rm -rf /etc/selinux/targeted/active/modules/100/mysql
[root@VM-0-8-centos]# rm -rf /usr/lib64/mysql

六、删除mysql配置文件

[root@VM-0-8-centos qbs]# rm /etc/my.cnf

七、检查是否还有mysql软件，如果有则继续删除即可

[root@VM-0-8-centos]# rpm -qa | grep mysql

八、删除Mariadb

[root@VM-0-8-centos qbs]# rpm -e --nodeps mariadb-libs-5.5.68-1.el7.x86_64

九、mysql5.7.38下载地址

https://downloads.mysql.com/archives/community/

十、手动下载后上传到服务器

十一、或者执行命令下载

[root@VM-0-8-centos]# wget https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.38-1.el7.x86_64.rpm-bundle.tar

十二、新建文件夹并放入其中

[root@VM-0-8-centos]# mkdir mysql
[root@VM-0-8-centos]# mv mysql-5.7.38-1.el7.x86_64.rpm-bundle.tar mysql/
[root@VM-0-8-centos]# cd mysql

十三、解压安装包

[root@VM-0-8-centos mysql]# tar -xvf mysql-5.7.38-1.el7.x86_64.rpm-bundle.tar 

十四、按顺序安装

[root@VM-0-8-centos mysql]# rpm -ivh mysql-community-common-5.7.38-1.el7.x86_64.rpm
[root@VM-0-8-centos mysql]# rpm -ivh mysql-community-libs-5.7.38-1.el7.x86_64.rpm 
[root@VM-0-8-centos mysql]# rpm -ivh mysql-community-libs-compat-5.7.38-1.el7.x86_64.rpm 
[root@VM-0-8-centos mysql]# rpm -ivh mysql-community-client-5.7.38-1.el7.x86_64.rpm
[root@VM-0-8-centos mysql]# rpm -ivh mysql-community-server-5.7.38-1.el7.x86_64.rpm 

十五、修改数据库数据归属用户并且添加写的权限

[root@VM-0-8-centos mysql]# chown mysql:mysql -R /var/lib/mysql
[root@VM-0-8-centos lib]# chmod -R 777 /var/lib/mysql

十六、初始化

[root@VM-0-8-centos mysql]# mysqld --initialize

十七、重启mysql服务

[root@VM-0-8-centos lib]# systemctl start mysqld

十八、查看初始密码

[root@VM-0-8-centos lib]# cat /var/log/mysqld.log | grep password
2022-10-17T03:55:17.909384Z 1 [Note] A temporary password is generated for root@localhost: *I)0jh=j*nae

十九、访问mysql

[root@VM-0-8-centos lib]# mysql -u root -p

二十、设置新密码

mysql> alter user user() identified by 'root';

二十一、刷新权限

mysql> flush privileges;

二十二、重启mysql服务

[root@VM-0-8-centos lib]# systemctl restart mysqld

二十三、配置远程连接并刷新

mysql> grant all privileges on *.* to 'root'@'%' identified by 'root' with grant option;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

二十四、配置数据库忽略大小写

vim /etc/my.cnf  加上  lower_case_table_names=1 ，然后再执行重启命令 systemctl restart mysqld 即可