CentOS7--安装Mysql

1、下载MySQL

wget http://repo.mysql.com/mysql80-community-release-el7-6.noarch.rpm

 

 

 2、安装Yum Repository

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

3、安装Mysql 服务器

yum -y install mysql-community-server

问题：获取 GPG 密钥失败:[Errno 14] curl#37 - "Couldn't open file /etc/pki/rpm-gpg/

解决：打开/etc/yum.repos.d/mysql-community.repo,更改对应版本的gpgcheck=0

 

4、启动Mysql

systemctl start  mysqld.service

相关命令：

5、查看Mysql运行状态

systemctl status mysqld.service

 6、查询Mysql初始密码

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

 

 最后面的就是Mysql的初始密码

7、修改密码

mysql -u root -p

ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password';

如果出现如下错误：

 

 是以为密码的复杂度不符合默认规定，如下命令查看mysql默认密码复杂度：

SHOW VARIABLES LIKE 'validate_password%';

 

 解决该错误：

改密码复杂度参考如下命令：

set global validate_password_policy=LOW;

 

 

set global validate_password_length=6;

 

 8、开启远程访问

use mysql;

update user set host = '%' where user = 'root';

# 即刻生效
flush privileges;