centos7下安装mysql5.7

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

yum -y install wget

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

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

下图表示安装成功

yum install mysql-community-server

systemctl start mysqld

systemctl status mysqld

systemctl enable mysqld

systemctl daemon-reload

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

查找生成的默认密码:

root/root

一开始修改密码的时候一直错误.后来查找了资料才发现,原来mysql5.7有一个密码策略机制,必须使用大小写加特殊字符加数字才可以是密码..所以我们要改策略,或者不使用这个密码策略.

修改密码的异常

在ect/my.conf下面添加validate_password=off

然后重启,mysql systemctl restart service;;

再重新查看密码配置策略.

重新设置密码

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

关闭防火墙,然后用远程连接一下数据库,查看一下...

systemctl status mysqld

sorry,禁止远程连接

修改远程连接的访问权限;

use mysql

select host,user from user;

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

退出,重启一下mysql,相信就可以连接成功了..

成功!!!!