CentOS6.4源码安装MySQL5.6.39

1.新增mysql帐号 

 groupadd mysql 

useradd -r -g mysql mysql

2.创建对应目录

mkdir -p  /opt/mysql

mkdir -p  /opt/mysql/databases

3.下载源码包

wget https://downloads.mysql.com/archives/get/file/mysql-5.6.39.tar.gz 

4.解压mysql安装包

tar -zxvf  mysql-5.6.39.tar.gz

cd  ./mysql-5.6.39

5.安装需要使用cmake编译以及gcc—c++等

yum –y install  gcc gcc-c++ bison ncurses-devel cmake

6.编译安装

cmake -DCMAKE_INSTALL_PREFIX=/opt/mysql -DMYSQL_DATADIR=/opt/mysql/databases -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_unicode_ci  -DWITH_SSL=system -DWITH_EMBEDDED_SERVER=1 -DENABLED_LOCAL_INFILE=1 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_DEBUG=0

make

make install

7.设置目录权限

chown -R mysql:mysql   /opt/mysql

cp  / opt/mysql/support-files/ my-default.cnf  /etc/my.cnf

8.数据库初始化

cd /opt/mysql/scripts

./mysql_install_db  --user=mysql --basedir=/opt/mysql --datadir=/opt/mysql/databases/

9.修改配置文件

[client]

#password       = your_password

port            = 3306

socket          = /opt/mysql/databases/mysql.sock

[mysqld]

port            = 3306

socket          = /opt/mysql/databases/mysql.sock

skip-external-locking

skip_name_resolve

key_buffer_size = 32M

max_allowed_packet = 32M

table_open_cache = 1024

sort_buffer_size = 4M

read_buffer_size = 8M

read_rnd_buffer_size = 4M

myisam_sort_buffer_size = 64M

bulk_insert_buffer_size = 64M

tmp_table_size = 32M

max_heap_table_size = 32M

thread_cache_size = 1000

query_cache_size = 0

query_cache_type = 0

max_connections=1000

max_connect_errors = 1000000

sync_binlog = 100

long_query_time = 2

slow_query_log_file = /opt/mysql/databases/mysql-slow_3306.log  #该参数与5.5版本有区别

datadir = /opt/mysql/databases

log_error=/opt/mysql/databases/error.log

pid-file=/opt/mysql/databases/mysql.pid

log-bin=mysql-bin

binlog_format=rows

server-id       = 1

innodb_write_io_threads = 8

innodb_read_io_threads = 8

innodb_open_files = 65535

innodb_flush_method = O_DIRECT

innodb_max_dirty_pages_pct=50

innodb_file_per_table = 1

innodb_flush_log_at_trx_commit=2

innodb_log_buffer_size = 32M

innodb_log_files_in_group = 2

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

10.创建软连接

ln -s /opt/mysql/bin/mysql  /usr/local/bin/mysql

11.配置MySQL服务

cp  /opt/mysql/support-files/mysql.server   /etc/init.d/mysqld

12.启动mysql服务 service mysqld start

13.修改初始密码：

/opt/mysql/bin/mysqladmin -u root password 123456 -S /opt/mysql/databases/mysql.sock