Linux下Mysql5.7.36版本的命令行解压安装

MySQL 是世界上最受欢迎的开源数据库。5.7版本在这几年也是比较流行，相比它之前的版本，有如下优势：
1、3倍更快的性能
2、InnoDB 相关改进
3、新的优化器
4、多源复制
5、GIS 相关改进
6、原生 JSON 支持
下面描述的是Linux下Mysql5.7.36版本的命令行解压安装：
首先获取到mysql5.7.36的压缩包

安装mysql-5.7.36-linux-glibc2.12-x86_64.tar.gz，目录为【/usr/local】

[root@centos7 ~]$ cd /usr/local

1. 解压

[root@centos7 local]$ tar -zxvf mysql-5.7.36-linux-glibc2.12-x86_64.tar.gz

2. 复制

[root@centos7 local]$ cp -r mysql-5.7.36-linux-glibc2.12-x86_64 /usr/local/mysql

3. 添加系统mysql组和mysql用户

[root@centos7 local]$ groupadd mysql
[root@centos7 local]$ useradd -r -g mysql mysql

4. 安装数据库

• 切到mysql安装目录

[root@centos7 local]$ cd /usr/local/mysql

• 修改当前目录拥有者为mysql用户

[root@centos7 mysql]$ chown -R mysql:mysql ./
[root@centos7 mysql]$ cd bin/

• 安装数据库-下面生成了root账户的临时密码

[root@centos7 bin]$ 
./mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

• 创建RSA private key

[root@centos7 bin]$ ./mysql_ssl_rsa_setup --datadir=/usr/local/mysql/data

5. 修改my.cnf

• 创建binlog存放目录（此举是为了下面在my.cnf文件中配置error.log和binlog相关参数）

[root@centos7 bin]$ mkdir -p /data/mysql/log
[root@centos7 bin]$ cd /data/mysql/log
[root@centos7 log]$ touch error.log

• 将/data/mysql/log整个目录及其子目录、子文件加入mysql用户组

[root@centos7 log]$ chown -R mysql:mysql /data/mysql/log

• 修改/etc/my.cnf文件

[root@centos7 log]$ vi /etc/my.cnf

配置如下参考：

[mysqld]
# basic settings #
user = mysql
port = 3306
sql_mode = "STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER"
autocommit = 1
server-id = 1
character_set_server = utf8mb4
transaction_isolation = READ-COMMITTED
lower_case_table_names = 1
explicit_defaults_for_timestamp = 1
max_allowed_packet = 16777216
event_scheduler = 1
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
socket = /tmp/mysql.sock
pid-file = /usr/local/mysql/data/mysqld.pid

# connection #
interactive_timeout = 1800
wait_timeout = 1800
lock_wait_timeout = 1800
skip_name_resolve = 1
max_connections = 1000
max_connect_errors = 1000000

# table cache performance settings #
table_open_cache = 4096
table_definition_cache = 4096
table_open_cache_instances = 128

# log settings #
log_error = /data/mysql/log/error.log
slow_query_log_file = /data/mysql/log/slow.log
log-bin = /data/mysql/log/mysql-bin
relay_log = mysql-relay-bin
general_log_file = general.log

slow_query_log = 1
log_queries_not_using_indexes = 1
log_slow_admin_statements = 1
log_slow_slave_statements = 1
log_throttle_queries_not_using_indexes = 10
long_query_time = 1
min_examined_row_limit = 100
binlog-rows-query-log-events = 1
log-bin-trust-function-creators = 1
expire-logs-days = 7
log-slave-updates = 1

# replication settings #
master_info_repository = TABLE
relay_log_info_repository = TABLE
sync_binlog = 1
gtid_mode = on
enforce_gtid_consistency = 1
log_slave_updates
binlog_format = ROW
binlog_rows_query_log_events = 1
relay_log = relay.log
relay_log_recovery = 1
slave_skip_errors = ddl_exist_errors
slave-rows-search-algorithms = 'INDEX_SCAN,HASH_SCAN'

replicate-ignore-db = mysql
replicate-ignore-db = information_schema
replicate-ignore-db = performance_schema
replicate-ignore-db = sys


[mysqld-5.7]
# new innodb settings #
loose_innodb_numa_interleave = 1
innodb_buffer_pool_dump_pct = 40
innodb_page_cleaners = 16
innodb_undo_log_truncate = 1
innodb_max_undo_log_size = 2G
innodb_purge_rseg_truncate_frequency = 128

# new replication settings #
slave-parallel-type = LOGICAL_CLOCK
slave-parallel-workers = 16
slave_preserve_commit_order = 1
slave_transaction_retries = 128

# other change settings #
binlog_gtid_simple_recovery = 1
log_timestamps = system
show_compatibility_56 = on

6. 设置mysql自动启动
7. 启动mysql服务并初始化密码

• 初始化mysql密码

[root@centos7 local]$ mysql -uroot -p
输入临时密码
sql>alter user 'root'@'localhost' identified by 'root';
sql>grant all privileges on *.* to'root'@'%' identified by 'root';

sql>flush privileges;

sql>exit