1. 创建用户
useradd -M -s /sbin/nologin mysql
2. 创建目录
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
授权：
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.进行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.初始化数据库
cd /usr/local/mysql-5.6/
scripts/mysql_install_db --user=mysql --datadir=/data/my3307-5.6/mysql/data/
11.开启服务并修改密码
/usr/local/mysql-5.6/support-files/mysql.server start
/usr/local/mysql-5.6/bin/mysqladmin -uroot -p password '123'
12.最终授权
chown -R mysql. /data/
chown -R mysql. /usr/local/mysql-5.*
13.查看默认配置文件读取顺序
/usr/local/mysql-5.6/bin/mysqld --verbose --help|grep -A 'Default options'
