1 環(huán)境準備

系統環(huán)境CentOS6.4 下載軟件 MySQL-5.6.14.tar.gz 下載地址：http://101.110.118.67/cdn.mysql.com/archives/mysql-5.6/mysql-5.6.14.tar.gz sphinx-2.2.11-release.tar.gz 下載地址：http://sphinxsearch.com/files/sphinx-2.2.11-release.tar.gz cmake-3.6.2.tar.gz 下載地址：https://cmake.org/files/v3.6/cmake-3.6.2.tar.gz 解壓 $ tar -zxvf NAME.tar.gz 

2 安裝程序

2.1 安裝依賴程序

gcc-c++  libstdc++-devel ncurses-devel bison autoconf automake libtool-2.* expat-dev* expat-2* mysql-devel 
安裝命令： yum -y install 包名（支持*） ：自動選擇y，全自動
2.2 安裝cmake
$ cd cmake-cmake-2.8.9 $ ./bootstrap $ make && make install 默認安裝在 /usr/local/bin 下面，要改變安裝路徑，在bootstrap命令中加入'--PRefix=PATH'選項。 
2.3 安裝mysql
$ cp -R sphinx-VERSION/mysqlse mysql-VERSION/storage/sphinx  $ cd mysql-VERSION  $ sh BUILD/autorun.sh $ ./configure --with-plugins=sphinx $ make && make install $ cd /usr/local/mysql-VERSION$ mkdir -p /var/log/mysql /usr/local/mysql/etc$ cp support-files/my-default.cnf /usr/local/mysql/etc/my.cnf    #然后修改my.cnf    [mysqld]    basedir         = /usr/local/mysql    datadir         = /usr/local/mysql/data    user 	      = root  #初使化數據庫$ scripts/mysql_install_db  --user=root --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data/ --defaults-file=/usr/local/mysql/etc/my.cnf  #起動并登錄 $ ./bin/mysqld_safe --defaults-extra-file=/usr/local/mysql/etc/my.cnf --user=root & $ mysql -uroot $ ln -s /usr/local/mysql/bin/mysql /usr/bin (when mysql: command not found) $ cp /usr/local/mysql/etc/my.cnf /etc/my.cnf  $ cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql $ service mysql start|stop|restart  /*添加服務到自啟動項*/  $ chkconfig --level 3 mysql on 
2.4 安裝sphinx engine
mysql>install plugin sphinx soname "ha_sphinx.so";  mysql>show engines; #ENGINE列表顯示出SPHINX表示安裝成功 
2.5 安裝sphinx
安裝sphinx
 $ ./configure --prefix=/usr/local/sphinx --with-mysql  $ make && make install 
3 mysql編碼設置
mysql編碼設置 編輯MySql的配置文件/etc/my.cnf 
–在 [mysqld] 標簽下加上三行 character_set_server = utf8 lower_case_table_names = 1 表名不區(qū)分大小寫（此與編碼無關） –在 [mysql] 標簽下加上一行 default-character-set = utf8 –在 [mysql.server]標簽下加上一行 default-character-set = utf8 –在 [mysqld_safe]標簽下加上一行 default-character-set = utf8 –在 [client]標簽下加上一行 default-character-set = utf8