CentOS7安装MySQL5.7

1.下载RPM安装包

mysql的rpm包,安装起来简单,解压版的mysql还需要做许多配置,稍有不慎就会出错!!!

img

下载后的安装包是这个样子的

img

2.安装依赖

2.1 查看linux上是否已经安装了mysql,有则卸载

一般centos7默认安装了mariadb,这里把它卸载。

[root@gmtgo ~]# rpm -qa|grep mariadb
mariadb-libs-5.5.68-1.el7.x86_64
[root@gmtgo ~]# rpm -e --nodeps mariadb-libs-5.5.68-1.el7.x86_64

2.2 安装mysql5.7所需要的依赖

[root@gmtgo ~]# yum install -y  libaio perl net-tools

3.安装mysql5.7

3.1 解压MySQL5.7安装包

解压完后会有很过rpm文件,这些就是我们需要安装的。

[root@gmtgo ~]# tar -xvf  mysql-5.7.35-1.el7.x86_64.rpm-bundle.tar 
mysql-community-client-5.7.35-1.el7.x86_64.rpm
mysql-community-common-5.7.35-1.el7.x86_64.rpm
mysql-community-devel-5.7.35-1.el7.x86_64.rpm
mysql-community-embedded-5.7.35-1.el7.x86_64.rpm
mysql-community-embedded-compat-5.7.35-1.el7.x86_64.rpm
mysql-community-embedded-devel-5.7.35-1.el7.x86_64.rpm
mysql-community-libs-5.7.35-1.el7.x86_64.rpm
mysql-community-libs-compat-5.7.35-1.el7.x86_64.rpm
mysql-community-server-5.7.35-1.el7.x86_64.rpm
mysql-community-test-5.7.35-1.el7.x86_64.rpm

3.2 安装MySQL5.7

rpm -ivh mysql-community-common-5.7.35-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.35-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-compat-5.7.35-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.35-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.35-1.el7.x86_64.rpm

3.3 运行MySQL

# 启动MySQL服务
[root@gmtgo ~]# systemctl start mysqld
# 查看MySQL运行状态
[root@gmtgo ~]# systemctl status mysqld
● mysqld.service - MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; disabled; vendor preset: disabled)
   Active: inactive (dead)
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html


# 设置为开机自启
[root@gmtgo ~]# systemctl enable mysqld
Created symlink from /etc/systemd/system/multi-user.target.wants/mysqld.service to /usr/lib/systemd/system/mysqld.service.

3.4 修改密码

修改/etc/my.cnf设置密码复杂度:

[mysqld]
# 密码复杂度
# LOW 仅需需符合密码长度(由参数validate_password_length指定)
# MEDIUM 满足LOW策略,同时还需满足至少有1个数字,小写字母,大写字母和特殊字符
validate_password_policy=LOW
# 设置密码的最小长度,默认值是8
validate_password_length = 6

查看临时密码

[root@gmtgo ~]# grep password /var/log/mysqld.log
2021-10-13T10:34:01.464297Z 1 [Note] A temporary password is generated for root@localhost: Cn)ypbPee23u

修改密码

  1. 用临时密码登录mysql -uroot -p

  2. 修改成新的密码:

    mysql> set password = password("123456");
  3. 开启远程连接,允许远程连接数据库

    mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH grant OPTION;
    # 刷新权限
    mysql> flush privileges;
  4. MySQL默认配置文件/etc/my.cnf


CentOS7安装MySQL5.7
https://www.gmtgo.com/73.html
作者
大帅
发布于
2021年10月23日
许可协议