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