1.安裝依賴包
yum?-y?install?wget?gcc?gcc-c++?gcc-g77?autoconf?automake?zlib*?fiex*
libxml*?ncurses-devel?libmcrypt*?libtool-ltdl-devel*?make?cmake?bison
bison-devel?ncurses-devel?perl
2.新建用戶組
groupadd?mysql
useradd?mysql?-g?mysql
3.上傳并解壓安裝包
cd?/home/home/app/tools
tar?-zxv?-f?mysql-5.6.19.tar.gz
cd?mysql-5.6.19
4.cmake編譯參數(shù)安裝
cmake?\
-DCMAKE_INSTALL_PREFIX=/home/app/mysql-5.6.19?\
-DMYSQL_UNIX_ADDR=/home/app/mysql-5.6.19/tmp/mysql.sock?\
-DDEFAULT_CHARSET=utf8?\
-DDEFAULT_COLLATION=utf8_general_ci?\
-DWITH_MYISAM_STORAGE_ENGINE=1?\
-DWITH_INNOBASE_STORAGE_ENGINE=1?\
-DWITH_ARCHIVE_STORAGE_ENGINE=1?\
-DWITH_BLACKHOLE_STORAGE_ENGINE=1?\
-DWITH_MEMORY_STORAGE_ENGINE=1?\
-DWITH_READLINE=1?\
-DENABLED_LOCAL_INFILE=1?\
-DMYSQL_DATADIR=/home/app/mysql-5.6.19/data?\
-DMYSQL_USER=mysql?\
-DMYSQL_TCP_PORT=3306
make?&&?make?install
ln?-s?/home/app/mysql-5.6.19?/home/mysql
5.?復(fù)制配置文件
sudo?cp?/home/app/mysql-5.6.19/support-files/my-default.cnf?/etc/my.cnf
6.添加系統(tǒng)變量
echo?'export?PATH=/home/app/mysql-5.6.19/bin:$PATH'?>>/etc/profile
echo?"export?PATH"?>>?/etc/profile
source?/etc/profile
echo?$PATH
7.進(jìn)入安裝路徑并授權(quán)mysql用戶:
cd?/home/app/mysql-5.6.19
mkdir?-p?/home/app/mysql-5.6.19/data
chown?-R?mysql.mysql?/home/app/mysql-5.6.19/
8.調(diào)整/tmp授權(quán)掸读,否則初始化會(huì)錯(cuò)誤:
chmod?-R?1777?/tmp
9.?執(zhí)行初始化:
cd?/home/app/mysql-5.6.19/scripts/
./mysql_install_db?--basedir=/home/app/mysql-5.6.19/?--datadir=/home/app/mysql-5.6.19/data/?--user=mysql
10.把服務(wù)啟動(dòng)腳本添加到/etc/init.d目錄下:
sudo?cp?/home/app/mysql-5.6.19/support-files/mysql.server?/etc/init.d/mysqld
11.啟動(dòng)MySQL服務(wù),設(shè)置密碼,設(shè)置開(kāi)機(jī)啟動(dòng)曙博。
/etc/init.d/mysqld?start
netstat?-lntup|grep?mysql
/home/app/mysql-5.6.19/bin/mysqladmin?-u?root?password?'root'
chkconfig?mysqld?on
echo?"ok!"