一、检测是否安装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 即可