配置LANMP环境（4）-- 安装MYSQL与安装相关软件，配置

cd ~

wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm

rpm -ivh mysql-community-release-el7-5.noarch.rpm

yum-config-manager --disable mysql56-community

yum-config-manager --enable mysql57-community-dmr

yum install mysql-community-server

启动mysql：
systemctl start mysqld

开机自动启动mysql：
systemctl enable mysqld

查看mysql进程是否开启：
ps aux |grep mysql

查看初始密码：
grep ‘temporary password‘ /var/log/mysqld.log

用初始密码登录：
mysql –uroot –p

降低密码安全等级：
mysql > set global validate_password_policy=0;

更改密码长度：
mysql > set global validate_password_length=0;

修改密码：
mysql > alter user ‘root‘@‘localhost‘ identified by ‘XXXXXXXX(8位密码)‘;

进入mysql配置文件：
vim /etc/my.cnf > 添加 default_password_lifetime=0

开启root帐号的远程操作权限：
mysql > use mysql
mysql > GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘%‘ IDENTIFIED BY ‘XXXXXXXX(root远程登录8位密码)‘ WITH GRANT OPTION;

重启mysql：
systemctl restart mysqld

执行：
set global sql_mode=‘‘;