1.检查MySQL及相关RPM包,是否安装,如果有安装,则移除
rpm -qa | grep -i mysql
2.移除依赖包
yum -y remove mysql-libs*
yum -y remove mysql*
3.开始下载包
wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
4.yum安装
yum -y install mysql57-community-release-el7-10.noarch.rpm
5.检查是否有mariadb
rpm -qa|grep mariadb
6.移除mariadb
rpm -e mariadb-libs-5.5.64-1.el7.x86_64 --nodeps
7.在线安装Mysql
yum -y install mysql-community-server
yum -y install mysql-lib*
yum -y install mysql-dev*
8.启动Mysql服务
systemctl start mysqld
9.查看运行状态
systemctl status mysqld.service
10.设置开机启动
systemctl enable mysqld
systemctl daemon-reload
11.mysql安装完成之后,在/var/log/mysqld.log文件中给root生成了一个临时的默认密码。
grep "password" /var/log/mysqld.log
12.进入mysql
mysql -u root -p
Enter password:
13.改原始密码
use mysql;
alter user 'root'@'localhost' identified by '你的密码';
14.更改密码校验策略
set global validate_password_policy=0;
set global validate_password_length=1;
15.修改/etc/my.cnf配置文件,在[mysqld]下添加编码配置,如下所示:
[mysqld]
character_set_server=utf8
init_connect='SET NAMES utf8'
16.卸载yum中mysql源
yum -y remove mysql57-community-release-el7-10.noarch