CentOS7安装Mysql

悠悠 2021-09-01 08:07 446阅读 0赞

### CentOS7安装Mysql ###

*  前言
 *   *  安装步骤（亲测有效）
 *  安装成功标志

# 前言 #

在安装Mysql之前首先确保CentOS安装成功。

## 安装步骤（亲测有效） ##

1.下载:https://downloads.mysql.com/archives/community/  
2.解压:tar -xvf mysql-5.7.29-linux-glibc2.12-x86\_64.tar.gz  
3.复制到文件夹:mv mysql-5.7.29-linux-glibc2.12-x86\_64 /usr/local/mysql  
4.进入刚所复制的文件夹内:cd /usr/local/mysql/  
5.添加系统mysql组和mysql用户 groupadd mysql 和useradd -r -g mysql mysql (注\#useradd -r参数表示mysql用户是系统用户，不可用于登录系统)  
6.设置权限:chown -R mysql:mysql /usr/local/mysql  
7.在/usr/local/mysql/下面创建data文件夹: mkdir data  
8.初始化:/usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/  
9.开启SSL:/usr/local/mysql/bin/mysql\_ssl\_rsa\_setup --datadir=/usr/local/mysql/data/  
10.授权:chown -R mysql:mysql /usr/local/mysql/data/  
11.配置my.cnf:vi /etc/my.cnf 配置如下:

[mysqld]
    character_set_server=utf8
    init_connect='SET NAMES utf8'
    basedir=/usr/local/mysql
    datadir=/usr/local/mysql/data
     
    [mysqld_safe]
    socket=/tmp/mysql.sock
    #是否区分大小写：0-区分大小写，1-不区分大小写
    lower_case_table_names = 1
    #不开启sql严格模式
    sql_mode="STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
    log-error=/var/log/mysqld.log
    pid-file=/usr/local/mysql/data/mysqld.pid

12.启动: service mysqld start  
13.设置开机自启动:替换mysqld为mysql.server cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld  
14.修改mysqld

basedir=/usr/local/mysql
    Datadir=/usr/local/mysql/data/

15.保存配置:chkconfig --add mysqld  
16.修改密码:mysql -uroot -p 自定义密码  
17.刷新:flush privileges;

# 安装成功标志 #

![在这里插入图片描述][20200807190159819.png]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQzNDE5MTA1_size_16_color_FFFFFF_t_70]

[20200807190159819.png]: /images/20210901/5be33a5ebe774c9b9cf6b6a1573afcda.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQzNDE5MTA1_size_16_color_FFFFFF_t_70]: /images/20210901/0a2bed7155204412bc898c5dfbc615e8.png