yum在线安装
下载MySQL
利用wget下载mysql源安装包
wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
安装mysql源
yum -y localinstall mysql57-community-release-el7-11.noarch.rpm
在线安装Mysql
yum -y install mysql-community-server
启动Mysql服务
systemctl start mysqld
设置开机启动
systemctl enable mysqld
mysql安装完成之后,在/var/log/mysqld.log文件中给root生成了一个临时的默认密码
cat /var/log/mysqld.log |grep 'password'
临时密码连接数据库
mysql5.7默认密码策略要求密码必须是大小写字母数字特殊字母的组合,至少8位
修改密码策略:
set global validate_password_policy=0;
set global validate_password_length=1;
修改密码:
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
利用新密码登录
设置允许远程登录
use mysql;
update user set host = '%' where user = 'root';
flush privileges;