1. 安装
1.1 创建目录
mkdir /usr/local/mysql
1.2 分配权限
chmod -R 777 /usr/local/mysql
1.3 切换目录
cd /usr/local/mysql
1.4 下载repo
wget https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm
1.5 安装repo
rpm -ivh mysql57-community-release-el7-9.noarch.rpm
1.6 切换目录
cd /etc/yum.repos.d/
1.7 完成安装
yum install mysql-server
2. 操作
2.1 启动
systemctl start mysqld
2.2 获取首次安装临时密码
grep 'temporary password' /var/log/mysqld.log
2.3 登陆(输入临时密码)
mysql -u root -p
3. 密码修改
3.1 查看密码策略
SHOW VARIABLES LIKE 'validate_password%';
3.2 设置密码强度为低
set global validate_password_policy=LOW;
3.3 设置密码长度
set global validate_password_length=6;
3.4 修改密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
4. 允许远程登陆
4.1 登陆并指定数据库后执行
update user set Host='%' where User='root';
4.2 刷新
flush privileges;