Centos7安装Mysql5.7，不踩坑教程

好长时间没处理Linux，一上来容易踩好多坑。废话不多说，先上干货。

一、环境处理

1、关掉防火墙禁用selinux

[root@localhost ~]# systemctl stop firewalld
[root@localhost ~]# setenforce 0

2、如果没有wget，可以下载

yum -y install wget

二、进入正题-RPM方式安装MySQL5.7

1、网络源下载

wget -i -c https://repo.mysql.com//mysql57-community-release-el7-10.noarch.rpm

2、安装

yum localinstall mysql57-community-release-el7-10.noarch.rpm 

yum -y install mysql-community-server

3、下载并解压rpm包

wget -c https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.36-1.el7.x86_64.rpm-bundle.tar

tar xf mysql-5.7.36-1.el7.x86_64.rpm-bundle.tar 

4、卸载mariadb-libs
mysql-community-libs-5.7.36-1.el7.x86_64.rpm和mariadb-libs冲突因此需要卸掉mariadb-libs

yum remove mariadb-libs

5、安装解压后的依赖包

yum localinstall mysql-community-server-5.7.36-1.el7.x86_64.rpm mysql-community-client-5.7.36-1.el7.x86_64.rpm mysql-community-common-5.7.36-1.el7.x86_64.rpm mysql-community-libs-5.7.36-1.el7.x86_64.rpm 

三、可以启动mysql了

systemctl start mysqld

开机自启动

systemctl enable mysqld

四、修改密码

1、临时密码登录修改密码
查看临时密码

 grep -i password /var/log/mysqld.log

使用临时密码登录

P=`awk '密码' /var/log/mysqld.log`

mysql -uroot -p$P

这样就登陆上去了

之后在mysql里面使用MySQL语句修改密码

ALTER USER root@localhost identified by ‘MySQL@123’;
2、已有密码直接登录修改即可

[root@localhost ~]# mysql -uroot -p'MySQL@123'

五、接下来一般用navicat进行连接，此时会产生报错，因为访问权限限制，我们继续

use mysql
select host from user where user='root';
update user set host = '%' where user = 'root';
flush privileges;

服务就可以正常运行了