centos7卸载自带数据库，安装mysql5.7

 

一、下载https://dev.mysql.com/downloads/mysql/5.7.html#downloads

上传到服务器

cd /usr/local/mysql

解压

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

ls

 

卸载原有mariadb

查询

rpm -qa | grep -i mariadb

删除原有安装

rpm -e --nodeps mariadb-libs-5.5.52-1.el7.x86_64

rpm -e --nodeps ........

rm -rf /etc/my.cnf

rm -rf /var/lib/mysql

由于mysql的server端需要perl语言的支持，因此我们还需要在系统中安装perl支持：

安装perl

yum install perl -y

  由于我们上面解压出来的几个rpm包有依赖关系，所以我们需要按照顺序执行安装：

1. rpm -ivh mysql-community-common-5.7.23-1.el7.x86_64.rpm

2. rpm -ivh mysql-community-libs-5.7.23-1.el7.x86_64.rpm

3. rpm -ivh mysql-community-client-5.7.23-1.el7.x86_64.rpm

4. rpm -ivh mysql-community-server-5.7.23-1.el7.x86_64.rpm

启动服务 

systemctl start mysqld.service

设置开机启动

systemctl enable  mysqld.service

修改密码

cat /var/log/mysqld.log，找到默认密码(搜password)

mysql -u root -p

输入默认密码

set password = password('你的密码');

密码策略修改

grant all privileges on *.* to 'root' @'%' identified by '123456';

flush privileges;