CentOS 7 中mysql 的安装详解

Mysql 下载地址：

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

下载成功后，将文件进行解压：

tar -zxvf mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz

将文件移动到/usr/local/下

mv mysql-5.7.17-linux-glibc2.5-x86_64 /usr/local/mysql

cd /usr/local/mysql/

创建数据库存放目录:

mkdir /usr/local/mysql/data

创建数据库日志存放目录：

mkdir /usr/local/mysql/logs

创建mysql用户组：

groupadd mysql

查看mysql用户组是否创建成功

tail /etc/group

创建mysql 用户，并指定所属用户组mysql 且限制登录，只允许运行数据库

useradd -r -g mysql -s /sbin/nologin mysql

查看mysql 用户：

tail /etc/shadow

授权mysql用户和mysql用户组拥有/usr/local/mysql 目录的访问权限

chown -R mysql:mysql /usr/local/mysql/

进入mysql的bin目录下，初始化数据库的基本信息：

cd /usr/local/mysql/bin

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

./mysql_ssl_rsa_setup --datadir=/usr/local/mysql/data/

进入mysql 的support-files目录下，将my-default.cnf复制到/etc下并重命名my.cnf

cd /usr/local/mysql/support-files/

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

编辑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]

# 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 = 1G

# 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 =/usr/local/mysql
datadir =/usr/local/mysql/data
port = 3306
server_id = 22209
socket = /tmp/mysql.sock
binlog_format =statement
log-error=/usr/local/mysql/data/error.log
pid-file=/usr/local/mysql/data/mysql.pid
user=mysql

skip-grant-tables


# 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_bin_trust_function_creators=on

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
lower_case_table_names=1

再复制mysql.server 到/etc/init.d/mysql下
cp mysql.server /etc/init.d/mysql

编辑/etc/init.d/mysql 配置文件并保存：