1、首先去官网下载支持centos7版本的数据库mysql-5.7.12-1.el7.x86_64.rpm-bundle.tar,在本地解压后传到centos7系统中。
2、卸载mariadb:
查询:rpm -qa|grep mariadb 将查询出来的mariadb文件用下面的命令卸载:
yum -y remove mariadb-libs-5.5.41-2.el7_0.x86_64
3、cd进入到数据库文件夹中依次执行:
rpm -ivh mysql-community-common-5.7.12-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.12-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.12-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.12-1.el7.x86_64.rpm
rpm -ivh mysql-community-devel-5.7.16-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-compat-5.7.16-1.el7.x86_64.rpm
4、启动数据库:systemctl start mysqld
如果出现:Job for mysqld.service failed. See 'systemctl status mysqld.service' and 'journalctl -xn' for details.出现这样的错误提示,我们先查看一下/var/lib/mysql-files目录是否存在,执行命令:ls -ld /var/lib/mysql-files。如果不显示任何信息就表示不存在,执行命令:mkdir /var/lib/mysql-files,创建/var/lib/mysql-files目录。这时,我们试着执行命令:systemctl start mysqld。如果还出现和下图一样的提示,我们执行另一条命令:chown -R mysql:mysql /var/lib/mysql
5、找回root密码:
vi /var/log/mysqld.log 在日志中找到下面的那句:
A temporary password is generated for root@localhost: sNtJ7uij7A!j 后面就是root密码,
6、进入数据库设置密码:SET PASSWORD FOR 'root'@'localhost' = PASSWORD('Mysql@126');
或者是:alter user 'root'@'localhost' identified by 'Mysql@126'; 修改密码。如果报错:ERROR 1819 (HY000): Your password does NOT satisfy the CURRENT policy requirements。应该将密码设置的复杂一点,有大写字母有符号
set global validate_password_policy=0;//只验证长度
set global validate_password_length=1;//最小长度密码长度为1
然后再改密码:SET PASSWORD FOR 'root'@'localhost' = PASSWORD('123456');
FLUSH PRIVILEGES;
7、设置开机自启:systemctl enable mysqld