🍉Linux安装mysql5

一、下载mysql安装包

wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm

二、安装mysql

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

三、检测是否安装成功

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

四、选择安装版本

#进入此文件可以看到mysql5的各种版本
#其中enabled=1是选择安装，enabled=0是不安装，文件内默认为5.7
vim /etc/yum.repos.d/mysql-community.repo    

mysql-community.repo文件

[mysql-connectors-community]
name=MySQL Connectors Community
baseurl=http://repo.mysql.com/yum/mysql-connectors-community/el/7/$basearch/
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

[mysql-tools-community]
name=MySQL Tools Community
baseurl=http://repo.mysql.com/yum/mysql-tools-community/el/7/$basearch/
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
[mysql-connectors-community]
name=MySQL Connectors Community
baseurl=http://repo.mysql.com/yum/mysql-connectors-community/el/7/$basearch/
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

[mysql-tools-community]
name=MySQL Tools Community
baseurl=http://repo.mysql.com/yum/mysql-tools-community/el/7/$basearch/
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

# Enable to use MySQL 5.5
[mysql55-community]
name=MySQL 5.5 Community Server
baseurl=http://repo.mysql.com/yum/mysql-5.5-community/el/7/$basearch/
enabled=0
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

# Enable to use MySQL 5.6
[mysql56-community]
name=MySQL 5.6 Community Server
baseurl=http://repo.mysql.com/yum/mysql-5.6-community/el/7/$basearch/
enabled=0
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

[mysql57-community]
name=MySQL 5.7 Community Server
baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/7/$basearch/
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

[mysql-tools-preview]
name=MySQL Tools Preview
baseurl=http://repo.mysql.com/yum/mysql-tools-preview/el/7/$basearch/
enabled=0
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556

五、安装mysql

yum install mysql-community-server 
#直接这样安装5.7可能会报以下错误
# 若没有报以下错误直接跳过解决问题的命令

导致这样的原因是MySQL GPG 密钥已过期导致使用下方命令重新进行安装

 # 更新GPG秘钥
 #安装mysql
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022 
yum install mysql-community-server  

六、开启mysql并设置自启

# 开启mysql服务
 # 设置开机自启
systemctl start mysqld    
systemctl enable mysqld  

七、修改mysql的密码

7.1、mysql5.7

7.1.1、查看初始密码

# 在安装完mysql5.7后，会自动生成一个密码，使用下方命令可查看密码：
grep 'temporary password' /var/log/mysqld.log   

7.1.2、修改密码

 # 登录mysql 使用上方命令查看的密码进行登录
# 此处修改密码有限制规则  这里进行修改规则

 #设置密码的长度为4位以上
 #设置密码的简易程度最低
 #修改root用户的密码为root
mysql -uroot -p 
set global validate_password_length=4;  
set global validate_password_policy=0;    
set password for 'root'@'localhost'=password('root');   

7.2、mysql5.6

#跳过密码进行登录
#修改root用户的密码为root 
mysql -uroot --skip-password 
set password for 'root'@'localhost'=password('root');  

八、设置远程登录

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;