19. Linux MySQL安装（CentOS -7）

Linux MySQL5.7.13 安装教程

Author：xushuyi

借鉴Linux Ret Hat 6.7系统 MySQL安装，本文档适用于 CentOS - 7 系统环境。

1. 系统约定

1、安装包下载目录：/data/software

2、MySQL安装目录位置：/usr/local/mysql

3、数据库保存位置：/data/mysql

4、日志保存位置：/data/log/mysql

5、检查磁盘大小：df -h

2. 下载MySQL

1、官网地址：https://dev.mysql.com/downloads/mysql/

2、阿里提供下载地址：http://ftp.kaist.ac.kr/mysql/Downloads/?spm=a2c6h.12873639.0.0.142042dfZFX7yg

2、执行命令如下：

#mkdir /data/software

#cd /data/software

#wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.13-linux-glibc2.5-x86_64.tar.gz

#wget http://ftp.kaist.ac.kr/mysql/Downloads/MySQL-5.7/mysql-5.7.34-linux-glibc2.12-x86_64.tar.gz

3、解压压缩包到目标位置

# mkdir /usr/local/mysql

#cd /dat/software

#pwd

执行后如下：

#ls

#cd /usr/local

#pwd

# tar -xzvf /data/software/mysql-5.7.13-linux-glibc2.5-x86_64.tar.gz

#ls

--修改文件名

# mv mysql-5.7.13-linux-glibc2.5-x86_64 mysql

#ls

4、创建数据仓库目录

--/data/mysql 数据仓库目录

# mkdir /data/mysql

#ls /data/

3. 安装MySQL

1、新建mysql用户、组及目录

# groupadd mysql

# useradd -r -s /sbin/nologin -g mysql mysql -d /usr/local/mysql

---新建 msyql用户禁止登录shell

2、改变目录属有者

#cd /usr/local/mysql

#pwd

#chown -R mysql .

#chgrp -R mysql .

#chown -R mysql /data/mysql/

3、配置参数

#bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql

此处需要注意记录生成的临时密码，如上文：*gre1Y::Q<A-

#bin/mysql_ssl_rsa_setup --datadir=/data/mysql

4、修改系统配置文件

#cp my-default.cnf /etc/my.cnf

#cp mysql.server /etc/init.d/mysql

#vim /etc/init.d/mysql

修改以下内容：

#vim /etc/my.cnf

修改以下内容：

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.

[mysqld]
skip-name-resolve
lower_case_table_names=1
# max_connections = 2000
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin

# These are commonly set, remove the # and set as required.
# basedir = .....
# datadir = /var/lib/mysql/
# port = .....
# server_id = .....
# socket = .....

# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
log_error = /data/log/mysql/error.log
#err-log = /var/log/mysqld.log
#pid-file = /var/lib/mysql/localhost.localdomain.pid

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES