1. 下载rpm:
wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
2. 更新源:
sudo rpm -Uvh mysql57-community-release-el7-8.noarch.rpm
3. 检查是否可用:
yum repolist enabled | grep "mysql.*-community.*"
出现下面信息就代表成功:
mysql-connectors-community/x86_64 MySQL Connectors Community 21
mysql-tools-community/x86_64 MySQL Tools Community 36
mysql57-community/x86_64 MySQL 5.7 Community Server 110
4. 安装mysql:
sudo yum install mysql-community-server
5 .启动mysqld
sudo service mysqld start
如果没启动就连接的话,就会出现下面的错误:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
6.找到mysql自动分配的临时密码:
sudo grep 'temporary password' /var/log/mysqld.log
7. 修改密码:
下面的命令均在mysql交互终端中执行:
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456'
一般来说这个密码是属于一个弱强度密码,mysql不会接收这个密码,并产生下面的报错信息:
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
这个时候就降低Mysql的密码检验强度:
set global validate_password_policy=0;
这个设置下会只检查长度,默认长度为8,也就是是说密码长度至少为8.
要查看这个长度的值,可以这样做:
select @@validate_password_length;
修改密码长度:
set global validate_password_length=7;
然后就可以修改密码了。
需要注意的是:
MySQL5.7.6之后,修改密码要这样修改
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';
MySQL 5.7.5和之前的版本,需要用下面的方式:
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPass');
参考资料:
http://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html
http://dev.mysql.com/doc/refman/5.7/en/linux-installation-yum-repo.html