mysql 5.7 centos7.3 安装

1.安装wget

yum install wget

2.wget 下载

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

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

3.安装mysql

yum install mysql-community-server

4.启动mysql 服务

systemctl start mysqld

5.开机启动

systemctl enable mysqld

systemctl daemon-reload

6.修改root本地登录密码

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

查密码

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

登录mysql

mysql -uroot -p

7.改密码

my.cnf文件加

5.7有密码校验validate_password = off

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

flush privileges;

8.修改ip权限

use mysql

update user set host = '%' where user ='root';

flush privileges;