centos 安装mysql5.7

安装

yum -y install https://repo.mysql.com/mysql57-community-release-el6-11.noarch.rpm
yum update -y
yum -y install mysql-community-server
service mysqld start

查看密码

grep 'temporary password' /var/log/mysqld.log
# 显示如下
2017-12-20T15:32:24.436697Z 1 [Note] A temporary password is generated for root@localhost: th.otyKdt0f.

mysql -uroot -p
# 输入上面生成的密码登录

密码就是：

**修改密码**

ALTER USER ‘root‘@’localhost’ IDENTIFIED BY ‘MyNewPass4!’;

**修改远程登录**

use mysql;
GRANT ALL PRIVILEGES ON . TO ‘root‘@’%’ IDENTIFIED BY ‘password’ WITH GRANT OPTION;
FLUSH PRIVILEGES;
quit();

service mysqld restart
service iptables stop
`

• mysql

• 运维

扫一扫，分享到微信