centos7安装mysql5.7

1、安装wget工具

yum install wget

2、下载mysql源安装包

wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm

3、安装MySQL源

yum localinstall mysql57-community-release-el7-8.noarch.rpm

4、检查MySQL源是否安装成功

yum repolist enabled | grep "mysql.*-community.*"

5、安装MySQL

yum install -y mysql-server mysql-client mysql-devel

6、启动MySQL服务

systemctl start mysqld

7、查看MySQL的启动状态

systemctl status mysqld

8、开机启动

systemctl enable mysqld
systemctl daemon-reload

9、获取初始密码

MySQL安装完成之后，在/var/log/mysqld.log文件中给root生成了一个默认密码。通过下面的方式找到root默认密码，然后登录mysql进行修改：

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

10、修改root默认密码

alter user 'root'@'localhost' identified by 'password';
或
set password for 'root'@'localhost'=password('password');

11、配置默认编码为utf8

修改/etc/my.cnf配置文件，在[mysqld]下添加编码配置，如下所示：

[mysqld]
character_set_server=utf8
init_connect='SET NAMES utf8'

12、创建远程连接用户

grant all privileges on *.* to 'user'@'%' identified by 'password' with grant option;

13、重启服务

systemctl restart mysqld