CentOS 7 MySQL安装步骤

# 下载mysql源安装包(下载完成以后会在home目录下面存放下载的文件)
shell> wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
# 安装mysql源
shell> yum localinstall mysql57-community-release-el7-8.noarch.rpm
#检查mysql源是否安装成功
shell> yum repolist enabled | grep "mysql.*-community.*"
#安装MySQL
shell> yum install mysql-community-server
#启动MySQL服务
shell> systemctl start mysqld
#开机启动
shell> systemctl enable mysqld

shell> systemctl daemon-reload

#查看初始配置(包括密码)
shell> grep 'temporary password' /var/log/mysqld.log
#登录数据库(通过上一个步骤获取配置的密码用来登陆)
shell>mysql -uroot -p
#降低数据库密码验证强度(默认密码强度很高，不降低强度会不允许修改,命令行最后必须用';',否则不会执行)
mysql> set global validate_password_policy=0;
#修改密码(初始密码太复杂，不便宜记忆)

mysql> set PASSWORD = PASSWORD('123456');

#修改允许远程访问(执行这一步钱后建议重启MySQL服务：systemctl restart mysqld)
mysql> grant all privileges on *.* to 'root'@'%' identified by '123456';
mysql> flush privileges;
#关闭防火墙以开放3006端口
shell> systemctl stop firewalld.service    #停止firewall
shell> systemctl disable firewalld.service #禁止firewall开机启动