linux环境安装Mysql 5.7.13教程

linux环境Mysql 5.7.13安装教程分享

1系统目录创建

安装文件下载目录：/data/software

Mysql目录安装位置：/usr/local/mysql

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

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

2下载mysql

在官网：http://dev.mysql.com/downloads/mysql/ 中，选择以下版本的mysql下载：

执行如下命名：

#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

3解压压缩包到目标位置

# cd /usr/local

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

4创建数据仓库目录和日志目录

# mkdir -p /data/mysql

# mkdir -p /data/log/mysql

5新建mysql用户、组及目录

该用户禁止shell登录，同时修改用户目录权限

# cd /usr/local/mysql

# chown -R mysql .

# chgrp -R mysql .

# chown -R mysql:mysql /data/mysql/

# chown -R mysql:mysql /data/log/

6配置参数

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

此处需要注意记录生成的临时密码，如上文： 8;xqiGZr:CiV

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

7修改系统配置文件

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

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

# vim /etc/init.d/mysql

修改以下内容：

# vim /etc/my.cnf

修改以下内容：

[client]

port = 3306

socket = /usr/local/mysql/mysql.sock

[mysql]

no-auto-rehash

default-character-set=utf8

[mysqld]

socket = /usr/local/mysql/mysql.sock

basedir = /usr/local/mysql

max_allowed_packet = 64M

datadir = /data/mysql

explicit_defaults_for_timestamp = true

skip-ssl

secure-file-priv = NULL

lower_case_table_names = 1

back_log = 300

max_connections = 3000

max_connect_errors = 100

table_open_cache = 4096

external-locking = FALSE

max_allowed_packet = 64M

sort_buffer_size = 32M

join_buffer_size = 32M

thread_cache_size = 16

query_cache_size = 128M

query_cache_limit = 4M

thread_stack = 512K

transaction_isolation = REPEATABLE-READ

tmp_table_size = 128M

max_heap_table_size = 128M

character-set-server=utf8

long_query_time = 6

slow_query_log_file = /data/log/mysql/slow.log

[mysqld_safe]

open-files-limit = 8192

log-error=/data/log/mysql/mysql_3306.err

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

9启动mysql

# ./bin/mysqld_safe --user=mysql &

# ./bin/mysql --user=root –p

--输入第6步生成的临时密码

mysql> set password=password('123456');

mysql> grant all privileges on *.* to root@'%' identified by '123456';

mysql> flush privileges;

mysql> use mysql;

mysql> select host,user from user;

10添加系统路径

# vim /etc/profile

添加：

export PATH=/usr/local/mysql/bin:$PATH

如下：

# source /etc/profile

11配置mysql自动启动

# chmod 755 /etc/init.d/mysql

# chkconfig --add mysql

# chkconfig --level 345 mysql on