Linux Centos7 安装Mysql

1、安装wget

yum install wget

2、下载 Yum Repository

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

3、安装 Yum Repository

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

4、安装MySQL

yum -y install mysql-community-server

5、启动MySQL

systemctl start  mysqld.service

6、查看运行状态

systemctl status mysqld.service

7、获取初始密码

grep "password" /var/log/mysqld.log

8、进入数据库

mysql -uroot -p

9、初始化密码

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'newPassword,.';

#新密码设置的时候如果设置的过于简单会报错！

10、查看密码规则

mysql> SHOW VARIABLES LIKE 'validate_password%';

11、修改密码规则

mysql> set global validate_password_policy=0;

mysql> set global validate_password_length=1;

12、修改密码

mysql> set password for root@localhost = password('root');

13、远程连接授权

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root';

14、授权立即生效

mysql> flush privileges;

15、卸载Yum Repository

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