CentOS7下安装MySQL5.7.22总结

1、下载RPM安装文件

wget http://repo.mysql.com/mysql-community-release-el7-7.noarch.rpm

2、安装mysql-community-release-el7-7.noarch.rpm

rpm -ivh mysql-community-release-el7-7.noarch.rpm

3、配置mysql安装源信息

vim /etc/yum.repos.d/mysql-community.repo

4、关闭gpgcheck

[mysql57-community]
name=MySQL 5.7 Community Server
baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/7/$basearch/
enabled=1
gpgcheck=0
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

5、安装MySQL

yum install mysql-community-server

6、启动MySQL服务

service mysqld start

7、添加开机启动服务

systemctl start mysqld.service

8、查看MySQL启动状态

service mysqld status

9、查看开机启动状态

systemctl status mysqld.service

10、查看MySQL5.7.22数据库初始化root密码

grep 'temporary password' /var/log/mysqld.log

例如，红色字体为自动生成的密码：

[Note] A temporary password is generated for root@localhost: .hora=:Uf8Bj

11、登录MySQL

mysql -uroot -p

12、修改root账号密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';