CentOS 通过yum在线安装MySQL5.7

CentOS 通过yum在线安装MySQL5.7
cd /usr/local
mkdir mysql

Step1: 检测系统是否自带安装mysql，并安装yum-config-manager，否则无法第三步设置
# yum list installed | grep mysql
# yum install yum-utils -y

Step2: 删除系统自带的mysql及其依赖(上一步的结果)
# yum -y remove mysql-libs.x86_64

Step3: 给CentOS添加rpm源，并且选择较新的源
# wget dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm
# yum localinstall mysql-community-release-el6-5.noarch.rpm
# yum repolist all | grep mysql
# yum-config-manager --disable mysql55-community
# yum-config-manager --disable mysql56-community
# yum-config-manager --enable mysql57-community-dmr
# yum repolist enabled | grep mysql

Step4:安装mysql 服务器
# yum install mysql-community-server

Step5: 启动mysql
# service mysqld start

Step6: 查看mysql是否自启动,并且设置开启自启动
# chkconfig --list | grep mysqld
# chkconfig mysqld on

7.查看状态
# service mysqld status
mysqld (pid 3066) is running.

8.修改密码
# grep 'temporary password' /var/log/mysqld.log
结果：2018-11-05T13:25:24.167477Z 1 [Note] A temporary password is generated for root@localhost: 8Id-kff:Ihef
# mysql -uroot -p
# 输入第一步的密码 8Id-kff:Ihef
# 修改 ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';


参考：
https://www.linuxidc.com/Linux/2016-10/136523.htm
https://dev.mysql.com/doc/refman/5.7/en/linux-installation-yum-repo.html