1. 創(chuàng)建用戶

useradd -M -s /sbin/nologin mysql

2. 創(chuàng)建目錄

mkdir -p /data/my3307-5.6/mysql
mkdir -p /data/my3307-5.6/mysql/data
mkdir -p /data/my3307-5.6/mysql/tmp
mkdir -p /data/my3307-5.6/mysql/log/iblog
mkdir -p /data/my3307-5.6/mysql/log/binlog
mkdir -p /data/my3307-5.6/mysql/run
mkdir -p /usr/loacl/mysq-5.6
mkdir /tools
授權(quán)：
chown -R mysql:mysql /data/my3307-5.6
chown -R mysql:mysql /usr/loacl/mysq-5.6

3. 下載源碼包

https://dev.mysql.com/downloads/mysql/
cd /tools
wget https://dev.mysql.com/downloads/file/?id=489600

4.下載boost軟件

https://www.boost.org/users/history/
wget https://sourceforge.net/projects/boost/files/boost/1.59.0/boost_1_59_0.tar.gz/download

5.解壓

tar xf mysq-5.6.46.tar.gz
tar xf boost-1.59.0.tar.gz -C mysq-5.6.46

6. 安裝cmake編譯工具

yum install -y cmake gcc gcc-c++ ncurses-devel bison zlib libxml openssl 

7.進(jìn)行cmake編譯mysql源文件

cmake \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql-5.6/ \
-DMYSQL_DATADIR=/data/my3307-5.6/mysql/data \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DEXTRA_CHARSETS=all \
-DWITH_EMBEDDED_SERVER=1 \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_FEDERATED_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DWITH_MEMORY_STORAGE_ENGINE=1 \
-DMYSQL_UNIX_ADDR=/data/my3307-5.6/mysql/run/mysql.sock \
-DMYSQL_TCP_PORT=3307 \
-DSYSCONFDIR=/data/my3307-5.6/mysql \
-DMYSQL_USER=mysql \
-DENABLE_DOWNLOADS=1 \
-DWITH_BOOST=/tools/mysql-5.7.26/boost \
-DWITH_READLINE=on

8.編譯并安裝

make & make install

9.編寫配置文件

vim /data/my3307-5.6/mysql/my.cnf
[client]
#password       = your_password
port            = 3307 
socket          = /data/my3307-5.6/mysql/run/mysql.sock
default-character-set=utf8

# Here follows entries for some specific programs

# The MySQL server

[mysqld]

port            = 3307 

### **character_set_server=utf8**

basedir=/usr/local/mysql-5.6/

datadir=/data/my3307-5.6/mysql/data

socket          = /data/my3307-5.6/mysql/run/mysql.sock

skip-external-locking

key_buffer_size = 16M

max_allowed_packet = 1M

table_open_cache = 64 

sort_buffer_size = 512K

net_buffer_length = 8K

read_buffer_size = 256K

read_rnd_buffer_size = 512K

myisam_sort_buffer_size = 8M

10.初始化數(shù)據(jù)庫

cd /usr/local/mysql-5.6/
scripts/mysql_install_db --user=mysql --datadir=/data/my3307-5.6/mysql/data/

11.開啟服務(wù)并修改密碼

/usr/local/mysql-5.6/support-files/mysql.server start
/usr/local/mysql-5.6/bin/mysqladmin -uroot -p password '123'

12.最終授權(quán)

chown -R mysql. /data/
chown -R mysql. /usr/local/mysql-5.*

13.查看默認(rèn)配置文件讀取順序

/usr/local/mysql-5.6/bin/mysqld --verbose --help|grep -A 'Default options'