建構LANMP架構一：源碼安裝mysql

yum install -y gcc gcc-c++ make ncurses-devel bison openssl-devel

tar zxf cmake-2.8.4.tar.gz

cd cmake-2.8.4                        源碼編譯cmake

./configure

gmake && gmake install

cmake -DCMAKE_INSTALL_PREFIX=/usr/local/lnmp/mysql \     #安裝目錄

-DMYSQL_DATADIR=/usr/local/lnmp/mysql/data \                       #資料庫存放目錄

-DMYSQL_UNIX_ADDR=/usr/local/lnmp/mysql/data/mysql.sock \   #Unix socket 檔案

-DWITH_MYISAM_STORAGE_ENGINE=1 \                                #安裝myisam存儲引擎

-DENABLED_LOCAL_INFILE=1 \                                                #允許從本地導入資料

-DDEFAULT_CHARSET=utf8 \                                                     #使用utf8字元

-DDEFAULT_COLLATION=utf8_general_ci \                              #校驗字元

-DEXTRA_CHARSETS=all                                                          #安裝所有擴充字元集

rm -fr CMakeCache.txt 每次提示報錯後，安裝完軟體後都需要删除緩存

make

make install

useradd -M -s /sbin/nologin mysql                                       添加mysql使用者

cd /usr/local/lnmp/mysql                                               

cp support-files/my-medium.cnf /etc/my.cnf              #根據你的主機記憶體複制mysql配置檔案

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

cd ..                                                                       回到上級目錄

chown -R mysql.mysql .

cd scripts/                                                                             

./mysql_install_db --user=mysql --basedir=/usr/local/lnmp/mysql/ --datadir=/usr/local/lnmp/mysql/data/

cd ..

chown -R root .

chown -R mysql data/

cd bin/ 所有腳本執行的指令都放在這裡

vi ~/.bash_profile

PATH=$PATH:$HOME/bin:/usr/local/lnmp/mysql/bin

source ~/.bash_profile

/etc/init.d/mysqld start

mysql_secure_installation                  #按提示完成mysql安全設定,生産環境推薦使用