mysql-init

创建一个新的数据之后，需要执行的操作

# 删除日志
echo '' > /var/log/MySQLd.log

# 启动 MySQL 
systemctl start MySQLd

# 查看初始密码
grep 'temporary password' /var/log/MySQLd.log

# 登录
MySQL -u root -p

# 修改密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'root';

# 设置密码强度
set global validate_password.policy=0;

# 设置密码长度(最小为4)
set global validate_password.length=4;

# 创建新用户
CREATE USER 'root'@'%' IDENTIFIED BY 'root';
CREATE USER 'eiscp'@'%' IDENTIFIED BY 'eiscp';

-- 授权
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON eiscp.* TO 'eiscp'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;