安装MySQL 5.7.11 详细步骤

最新推荐文章于 2021-03-17 01:26:48 发布

原创

最新推荐文章于 2021-03-17 01:26:48 发布 · 763 阅读

0 ·

CC 4.0 BY-SA版权

本文档详细介绍了在Linux系统中安装MySQL 5.7.11的步骤，包括解压安装包、创建配置文件my.cnf、设置目录权限、创建用户组和用户、配置环境变量、初始化数据库、启动服务、修改root用户密码以及分配权限等操作。

1.解压及创建目录

[root@hadoop39 ~]# cd /usr/local
[root@hadoop39 local]# tar xzvf mysql-5.7.11-linux-glibc2.5-x86_64.tar.gz -C /usr/local
[root@hadoop39 local]# mv mysql-5.7.11-linux-glibc2.5-x86_64 mysql /usr/local

修改mysql文件夹权限

[root@hadoop39 local]#

[root@hadoop39 local]# mkdir mysql/arch mysql/data mysql/tmp

2.创建my.cnf(见文件)：
[root@hadoop39 local]# vi /etc/my.cnf

将如下代码添加到my.cnf文件中：
[client]
port = 3306
socket = /usr/local/mysql/data/mysql.sock
default-character-set=utf8mb4

[mysqld]
port = 3306
socket = /usr/local/mysql/data/mysql.sock

skip-slave-start

skip-external-locking
key_buffer_size = 256M
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 4M
query_cache_size= 32M
max_allowed_packet = 16M
myisam_sort_buffer_size=128M
tmp_table_size=32M

table_open_cache = 512
thread_cache_size = 8
wait_timeout = 86400
interactive_timeout = 86400
max_connections = 600

# Try number of CPU's*2 for thread_concurrency
#thread_concurrency = 32

#isolation level and default engine
default-storage-engine = INNODB
transaction-isolation = READ-COMMITTED

server-id = 1739
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
pid-file = /usr/local/mysql/data/hostname.pid

#open performance schema
log-warnings
sysdate-is-now

binlog_format = ROW
log_bin_trust_function_creators=1
log-error = /usr/local/mysql/data/hostname.err
log-bin = /usr/local/mysql/arch/mysql-bin
expire_logs_days = 7

innodb_write_io_threads=16

relay-log = /usr/local/mysql/relay_log/relay-log
relay-log-index = /usr/local/mysql/relay_log/relay-log.index
relay_log_info_file= /usr/local/mysql/relay_log/relay-log.info

log_slave_updates=1
gtid_mode=OFF
enforce_gtid_consistency=OFF

# slave
slave-parallel-type=LOGICAL_CLOCK
slave-parallel-workers=4
master_info_repository=TABLE
relay_log_info_repositor