Linux（Centos7）yum安装 MySQL5.7

一、安装

1.下载mysql源安装包，更新检索秘钥

wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022

2.安装mysql源

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

3.检测源是否安装成功，显示如图即安装成功

yum repolist enabled | grep "mysql.*-community.*"

4.安装mysql服务

yum install mysql-community-server

5.开启mysql，查看mysql状态。如图即开启成功

systemctl start mysqld 
systemctl status mysqld

6.查看默认密码

grep 'temporary password' /var/log/mysqld.log 

7.登录mysql

#密码为上一步的默认密码
mysql -uroot -p

8.第一次登录需修改密码–(尽量复杂点，太简单容易修改不成功)

set password for 'root'@'localhost'=password('新密码');

9.开放远程权限

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION;  #开放远程权限
FLUSH PRIVILEGES; #刷新立即生效
systemctl restart mysqld  #重启mysql
systemctl stop firewalld #关闭防火墙

10.使用Navicat测试连接–(连接前注意关闭防火墙或者开放3306端口)

#1. 关闭防火墙
systemctl stop firewalld 

#2. 防火墙开放3306端口
firewall-cmd --zone=public --add-port=3306/tcp --permanent
systemctl restart firewalld   //重启

设置开机自启

systemctl enable mysqld              
systemctl daemon-reload 

查看版本及各文件目录

1. 版本查看

mysql -V              #方法一
rpm -qa | grep mysql  #方法二

2.查看各文件路径

#先用rpm -qa查出mysql-community-server,再用rpm -ql查mysql-community-server即可
rpm -qa | grep mysql 
rpm -ql mysql-community-server-5.7.41-1.el7.x86_64