centos 7 安装Mysql

下载安装mysql官方的 yum repository

wget http://dev.mysql.com/get/mysql57-communtiy-release-el7-10.noarch.rpm

yum -y install mysql57-community-release-el7-10.noarch.rpm

安装mysql

yum -y install mysql-community-server

启动mysql

systenctl start mysql.service

查看启动状态

systemctl status mysqld.service

在mysqld.log中查找密码

grep “password” /var/log/mysqld.log

登入数据库

mysql -uroot -p

修改mysql密码（新密码设置简单会报错）

alter user ‘root’@‘localhost’ inentified by ‘123.com’;

若报错修改mysql密码规范

set global validate_password_policy=0;

set global validate_password_length=1;

设置新密码

alter user ‘root’@‘localhost’ inentified by ‘123.com’;

开启远程访问

grant all privileges on *.* to 'root@%' identified by '123.com' with grant option;

立即生效

flush privileges；

因为安装了Yum Repository，以后每次yum操作都会自动更新，需要把这个卸载掉：

yum -y remove mysql57-community-release-el7-10.noarch

查看初始密码规则

show variables like ‘validate_password%’;