下载并安装MySQL官方的 Yum Repository
- wget?-i?-c?http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
yum安装
- yum?-y?install?mysql57-community-release-el7-10 .noarch.rpm
- yum?-y?install?mysql-community-server
配置数据库
- systemctl?start?mysqld.service?#启动MySQL
- systemctl?status?mysqld.service?#查看状态
- grep?"password"?/var/log/mysqld.log?#查看默认密码
- mysql?-uroot?-p?#进入数据库,使用查出来的默认密码登陆
- ALTER?USER?'root'@'localhost'?IDENTIFIED?BY?'new ?password';?#修改密码,new ?password为新密码
如果出现了:ERROR 1819 (HY000): Your password does not satisfy the current policy requirements错误,说明密码安全不满足mysql策略,可以使用以下命令调整策略
- set?global?validate_password_policy=0 ;#关闭繁杂度
- set?global?validate_password_length=1 ;#调整长度
开启远程
- grant all privileges on *.* to 'root'@' 1.1 . 1.1 ' identified by 'password' with grant option; #开启远程权限,其中 1.1 . 1.1 为授权IP,允许所有为%
- flush privileges;
- exit;