centos安装mysql
#
下载 rpmwget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
#
导入 rpmyum -y install mysql57-community-release-el7-10.noarch.rpm
#
yum 安装yum -y install mysql-community-server
#
启动systemctl start mysqld.service
#
初始化 root 密码查看 root 密码,在 root@localhost
后
grep "password" /var/log/mysqld.log
进入数据库 回车后会提示输入密码
mysql -uroot -p
输入初始密码,此时不能做任何事情,因为MySQL默认必须修改密码之后才能操作数据库
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password';
# 查看密码安全等级SHOW VARIABLES LIKE 'validate_password%';
# 设置为低等级set global validate_password_policy=0;set global validate_password_length=1;