MYSQL5.7详细安装步骤

川长思鸟来 2022-11-18 13:50 223阅读 0赞

# Mysql系列文章目录 #

提示：这里是Mysql的安装

--------------------

### 文章目录 ###

*  Mysql系列文章目录
 *  一、更换yum源（可做可不做）
 *  二、安装

# 一、更换yum源（可做可不做） #

1、打开 mirrors.aliyun.com，选择centos的系统，点击帮助  
2、执行命令：

yum install wget -y

3、改变某些文件的名称

mv /etc/yum.repos.d/CentOS-Base.repo /etc/yum.repos.d/CentOS-Base.repo.backup

4、执行更换yum源的命令

wget -O /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-6.repo

5、更新本地缓存

yum clean all
    yum makecache

# 二、安装 #

**查看系统中是否自带安装mysql**

yum list installed | grep mysql

![在这里插入图片描述][20210413154047197.png]  
**删除系统自带的mysql及其依赖（防止冲突）**

yum -y remove mysql-libs.x86_64

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyNzMxMzU4_size_16_color_FFFFFF_t_70]  
**安装wget命令**

yum install wget -y

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyNzMxMzU4_size_16_color_FFFFFF_t_70 1]  
**给CentOS添加rpm源，并且选择较新的源**

wget dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyNzMxMzU4_size_16_color_FFFFFF_t_70 2]  
**安装下载好的rpm文件**

yum install mysql-community-release-el6-5.noarch.rpm -y

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyNzMxMzU4_size_16_color_FFFFFF_t_70 3]  
**安装成功之后，会在/etc/yum.repos.d/文件夹下增加两个文件**  
![在这里插入图片描述][20210413154819873.png]  
**修改mysql-community.repo文件**  
原文件：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyNzMxMzU4_size_16_color_FFFFFF_t_70 4]  
**安装下载好的rpm文件**  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyNzMxMzU4_size_16_color_FFFFFF_t_70 5]

**使用yum安装mysql**

yum install mysql-community-server -y

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyNzMxMzU4_size_16_color_FFFFFF_t_70 6]  
**启动mysql服务并设置开机启动**

#启动之前需要生成临时密码，需要用到证书，可能证书过期，需要进行更新操作
    yum update -y
    #启动mysql服务
    service mysqld start
    #设置mysql开机启动
    chkconfig mysqld on

**获取mysql的临时密码**

grep "password" /var/log/mysqld.log

![在这里插入图片描述][20210413155441207.png]  
**使用临时密码登录**

mysql -uroot -p

**修改密码**

set global validate_password_policy=0;
    set global validate_password_length=1;
    ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

**修改远程访问权限**

grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;
    flush privileges;

**设置字符集为utf-8**

#在[mysqld]部分添加：
    character-set-server=utf8
    #在文件末尾新增[client]段，并在[client]段添加：
    default-character-set=utf8

[20210413154047197.png]: /images/20221022/45d2e3e2f4c7484b926b854e98024e48.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyNzMxMzU4_size_16_color_FFFFFF_t_70]: /images/20221022/5dfbe5d49a094347ac52aaa2d54ba0c8.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyNzMxMzU4_size_16_color_FFFFFF_t_70 1]: /images/20221022/1a8c4e822525409eb617153e8a02746d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyNzMxMzU4_size_16_color_FFFFFF_t_70 2]: /images/20221022/cb3ce892ee6b4cf2adbe44d6634016dc.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyNzMxMzU4_size_16_color_FFFFFF_t_70 3]: /images/20221022/11ddc2b6e59f4c208a9c8aba1ce318c5.png
[20210413154819873.png]: /images/20221022/06005403413040789911f2a15484245c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyNzMxMzU4_size_16_color_FFFFFF_t_70 4]: /images/20221022/eb19f9e32ee64781a04210d70d56811f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyNzMxMzU4_size_16_color_FFFFFF_t_70 5]: /images/20221022/ea79e72ae0664e309b1e600a2618cae9.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyNzMxMzU4_size_16_color_FFFFFF_t_70 6]: /images/20221022/6890464e951f455380a99b18b3dbabcc.png
[20210413155441207.png]: /images/20221022/792fe57a84a84e808555707e4fe47f8e.png