​ mysql编译安装脚本

系统版本: CentOS 7.2 amd64
mysql版本: MySql-5.6.25
脚本依赖: 需要联网 yum 安装 cmake、gcc 等工具。

tree ./
./
├── conf
│   └── my.cnf
├── mysql-5.6.25.tar.gz
└── mysql-server.sh

1 directory, 3 files

# 示例 2cpu/4GB虚拟机，请根据实际情况配置参数。
awk '!/^(#|$)/' conf/my.cnf

[client]
port    = 3306
socket  = /tmp/mysql.sock

[mysql]
no-auto-rehash

[mysqld]
user   = mysql
port   = 3306
socket = /tmp/mysql.sock
basedir  = /usr/local/mysql
datadir  = /usr/local/mysql/data
pid-file = /usr/local/mysql/data/mysql.pid
character_set_server = utf8
skip-name-resolve
long_query_time = 5
slow_query_log  = 1 
max_connections = 2000
max_connect_errors = 4000
explicit_defaults_for_timestamp = 1
tmp_table_size = 32M
max_heap_table_size = 32M
thread_cache_size = 100
default-storage-engine = INNODB
innodb_flush_log_at_trx_commit = 1
innodb_file_per_table = 1
innodb_buffer_pool_size = 2048M
innodb_log_file_size = 512M
key_buffer_size = 512M
log-bin=mysql-bin
binlog_format = mixed
server-id = 11
sync_binlog = 1
expire_logs_days = 15

[mysqldump]
quick
max_allowed_packet = 32M

# 使用脚本完成，mysql 编译、配置、安装步骤。

bash  mysql-server.sh
# 耐心等待， 笔者2cpu/4GB虚拟机编译时间大约20分钟左右。

/etc/init.d/mysqld start

mysql_secure_installation
# 初始root密码为空，需要进行安全配置，按照提示完成配置向导。

mysql -u root -p 
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 18
Server version: 5.6.25-log Source distribution

Copyright (c) 2000, 2015, Oracle. All rights reserved.

# ...省略

mysql>