CentOS 安装 MySQL 5.7.18

1. 下载 官方安装包 https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.18-linux-glibc2.5-x86_64.tar.gz

2. 将安装包 拷贝到 预设目录下，如 /home/admin/deploy/ ,我的用户名是admin

3. 解压安装包 tar zxvf mysql-5.7.18-linux-glibc2.5-x86_64.tar.gz

解压后的目录名太复杂，重命名：

    mv  mysql-5.7.18-linux-glibc2.5-x86_64  mysql

4. cd mysql 

执行 bin/mysqld--initialize--user=mysql --basedir=/home/admin/deploy/mysql --datadir=/home/admin/deploy/mysql/data

执行bin/mysql_ssl_rsa_setup

执行bin/mysqld_safe--user=admin

5. 创建配置文件 /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

[mysqld]

character_set_server=utf8

init_connect='SET NAMES utf8'

#

# 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 = 1024M

#

# Remove leading # to turn on a very important data integrity option: logging

# changes to the binary log between backups.

# log_bin

#

# 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

basedir=/home/admin/deploy/mysql

datadir=/home/admin/deploy/mysql/data

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

log-error=/home/admin/deploy/mysql/log/mysqld.log

pid-file=/home/admin/deploy/mysql/mysqld.pid

有些目录不会自动创建，需要手工创建

6.   cp support-files/mysql.server /etc/init.d/mysql

修改/etc/init.d/mysql

basedir=/home/admin/deploy/mysql
datadir=/home/admin/deploy/mysql/data

7. 启动 mysql

service mysql start