本文實例講述了centos7環(huán)境下源碼安裝mysql5.7.16的方法。，具體如下：

一、下載源碼包

下載mysql源碼包

http://mirrors.sohu.com/mysql/MySQL-5.7/mysql-5.7.16.tar.gz

二、安裝約定：

用戶名：mysql
安裝目錄：/data/mysql
數(shù)據(jù)庫目錄：/data/mysql/data

三、安裝準(zhǔn)備

1、添加用戶

> useradd -s /sbin/nologin mysql

2、建立目錄

> mkdir /data/mysql

3、改變目錄擁有者和所屬者

> chown -R mysql:mysql /data/mysql

4、安裝編輯所需的文件

> yum install gcc gcc-c++ cmake bison-devel ncurses-devel libaio libaio-devel

(*mysql5.7.5以上版本需要安裝boost)

> yum install boost boost-devel

5、解壓源碼包

> tar -xf mysql-5.7.16.tar.gz

四、編譯安裝

> cd /data/mysql-5.7.16> cmake /-DMYSQL_USER=mysql /-DCMAKE_INSTALL_PREFIX=/data/mysql /-DMYSQL_DATADIR=/data/mysql/data /-DSYSCONFDIR=/data/mysql /-DWITH_MYISAM_STORAGE_ENGINE=1 /-DWITH_INNOBASE_STORAGE_ENGINE=1 /-DWITH_MEMORY_STORAGE_ENGINE=1 /-DINSTALL_PLUGINDIR=/data/mysql/plugin /-DWITH_READLINE=1 /-DMYSQL_UNIX_ADDR=/data/mysql/mysql.sock /-DMYSQL_TCP_PORT=3306 /-DENABLED_LOCAL_INFILE=1 /-DWITH_PARTITION_STORAGE_ENGINE=1 /-DEXTRA_CHARSETS=all /-DDEFAULT_CHARSET=utf8 /-DDEFAULT_COLLATION=utf8_general_ci /-DDOWNLOAD_BOOST=1 /-DWITH_BOOST=/usr/local/boost

(*注意，如果出錯，需刪除CMakeCache.txt，重新運行配置)

關(guān)于上面參數(shù)的解釋如下：

#mysql用戶名-DMYSQL_USER=mysql#安裝路徑-DCMAKE_INSTALL_PREFIX=/data/mysql#數(shù)據(jù)文件存放位置-DMYSQL_DATADIR=/data/mysql/data#my.cnf路徑-DSYSCONFDIR=/data/mysql#支持MyIASM引擎-DWITH_MYISAM_STORAGE_ENGINE=1#支持InnoDB引擎-DWITH_INNOBASE_STORAGE_ENGINE=1#支持Memory引擎-DWITH_MEMORY_STORAGE_ENGINE=1#插件文件及配置路徑-DINSTALL_PLUGINDIR=/data/mysql/plugin#快捷鍵功能(我沒用過)-DWITH_READLINE=1#連接數(shù)據(jù)庫socket路徑-DMYSQL_UNIX_ADDR=/data/mysql/mysql.sock#端口-DMYSQL_TCP_PORT=3306#允許從本地導(dǎo)入數(shù)據(jù)-DENABLED_LOCAL_INFILE=1#安裝支持?jǐn)?shù)據(jù)庫分區(qū)-DWITH_PARTITION_STORAGE_ENGINE=1#安裝所有的字符集-DEXTRA_CHARSETS=all#默認(rèn)字符-DDEFAULT_CHARSET=utf8#校驗字符-DDEFAULT_COLLATION=utf8_general_ci#會自動下載boost-DDOWNLOAD_BOOST=1#指定boost目錄-DWITH_BOOST=/usr/local/boost

編譯安裝

> make && make install

復(fù)制配置文件

> cp /data/mysql/support-files/my-default.cnf /data/mysql/my.cnf

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

> /data/mysql/bin/mysqld /--defaults-file=/data/mysql/my.cnf /--initialize /--user=mysql /--basedir=/data/mysql /--datadir=/data/mysql/data /