一鍵編譯安裝mysql-5.6.17

標籤：編譯mysql

簡單編譯mysql5.6.17

設定檔my.cnf 請自行配置

cat mysql.sh

mkdir -p /opt/app
cd /opt/app

#建立檔案存放目錄

wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.17.tar.gz
tar -xf mysql-5.6.17.tar.gz
yum install -y make gcc-c++ cmake bison-devel  ncurses-devel

#下載軟體包並解壓同時安裝依賴庫

groupadd mysql
useradd -g mysql mysql

#添加使用者、組
cd /opt/app/mysql-5.6.17.tar.gz

#進入目錄並配置

cmake -DCMAKE_INSTALl_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/opt/mysql/data -DSYSCONFDIR=/usr/local/mysql/etc -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DMYSQL_TCP_PORT=3306 -DENABLED_LOCAL_INFILE=1 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DENABLE_DOWNLOADS=1

make && make install

#編譯完成

mkdir /usr/local/mysql/logs

#建立日誌存放目錄

chown -R mysql.mysql /usr/local/mysql/
#更改屬組、主
cd /usr/local/mysql/scripts/

#初始化資料庫

./mysql_install_db --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql/ --datadir=/opt/mysql/data/ --user=mysql

cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld
service mysqld restart

#啟動mysql

echo  MYSQL_HOME=/usr/local/mysql  >> /etc/profile
echo export PATH=${MYSQL_HOME}/bin:$PATH >> /etc/profile

source /etc/profile

#完成！！！

本文出自 “蝸牛的嘲諷” 部落格，請務必保留此出處http://imork.blog.51cto.com/11642843/1872705

一鍵編譯安裝mysql-5.6.17