CentOS7 64位下MySQL5.7安装与配置（YUM）

CentOS7 64位下MySQL5.7安装与配置（YUM）

# 下载mysql源安装包

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

 

安装mysql源

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

yum install mysql-community-server

 

systemctl start mysqld

开机启动

systemctl enable mysqld

systemctl daemon-reload

 

查看默认密码 

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

mysql -uroot -p

修改密码

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

注意：mysql5.7默认安装了密码安全检查插件（validate_password），默认密码检查策略要求密码必须包含：大小写字母、数字和特殊符号，并且长度不能少于8位。否则会提示ERROR 1819 (HY000): Your password does not satisfy the current policy requirements错误

添加远程账号

GRANT ALL PRIVILEGES ON *.* TO 'maoxu'@'%' IDENTIFIED BY 'MaoXu100!' WITH GRANT OPTION;

参考  https://www.linuxidc.com/Linux/2016-09/135288.htm