CentOS 安装MySQL 5.7

一，检查是否安装MySQL或Mariadb，卸载相关，放置后续安装出错

二，获取最新官方源

#把文件下载到home下的soft文件夹cd /home/soft
wget https://repo.mysql.com//mysql80-community-release-el7-5.noarch.rpm
#本地安装yum localinstall https://repo.mysql.com//mysql80-community-release-el7-5.noarch.rpm
#更新源并查询是否安装成功
yum clean all && yum makecache
#查询是否存在mysql的相关包
yum repolist enabled | grep "mysql.*-community.*"
yum repolist all | grep mysql

三，启用MySQL5.7源

四，安裝MySQL 5.7

# 禁用系统自带MySQL模块
yum module disable mysql

yum install mysql-community-server -y

# 安装如果报错，记得重命名

wget http://repo.mysql.com/RPM-GPG-KEY-mysql -O /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

五，设置密码

#启动并设置开机自启
systemctl start mysqld
systemctl enable mysqld
systemctl status mysqld

#查看版本
mysql --version

#查看初始root密码，并重新设置
grep 'temporary password' /var/log/mysqld.log

#登录mysql，并重新设置root密码
mysql -u root -p
输入初始密码

格式：mysql> set password for 用户名@localhost = password('新密码'); 
或者使用：ALTER USER 'root'@'localhost' IDENTIFIED BY 'root-password';

六，设置远程登录

#查看当前数据库
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.00 sec)

#设置允许远程
mysql> use mysql;

mysql> select user,host from user;

mysql> update user set host="%" where user="root";
#刷新权限
mysql> flush privileges;