mysql-5.6.17編譯安裝指令碼

標籤：mysql

#!/bin/bash
#Date:2017-04-21
#Author:Allen_Jol
#mysql-5.6.17_v2.0

#卸載內建的mysql-libs
rpm -e --nodeps mysql-libs

#安裝所需軟體依賴
yum -y install make gcc gcc-c++ ncurses ncurses-devel pcre pcre-devel zlib zlib-devel openssl openssl-devel

MDIR=/usr/local/src
cd $MDIR

ls *.tar.gz | xargs -n1 tar zxvf

#Mysql install
echo "============Mysql-5.6.17 install==========="
sleep 2
groupadd mysql
useradd -s /sbin/nologin -g mysql -M mysql
mkdir -p /usr/local/mysql/data

#編譯camke mysql5.5以後都用cmake代替原來的./configure
cd $MDIR/cmake-2.8.12.2
./configure
make && make install

sleep 2

#正式開始編譯安裝mysql
cd $MDIR/mysql-5.6.17/
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data -DSYSCONFDIR=/etc -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DMYSQL_UNIX_ADDR=/var/lib/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/src/boost_1_59_0

sleep 3
make && make install

sleep 2

#更改許可權
chmod +w /usr/local/mysql
chown -R mysql:mysql /usr/local/mysql

#初始化資料庫
/usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

#拷貝指令檔
\cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld

#給指令檔賦予許可權
chmod +x /etc/init.d/mysqld
#拷貝/my.cnf檔案
\cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf

#啟動mysql或者用/etc/init.d/mysqld start
service  mysqld  start
#開機自啟
chkconfig  mysqld  on
#更改mysql密碼
/usr/local/mysql/bin/mysqladmin -uroot password ‘123456‘

#配置環境變數
echo ‘export PATH=$PATH:/usr/local/mysql/bin‘>> /etc/profile
. /etc/profile

#如果不能直接登入mysql  手動source /etc/profile一下即可

本文出自 “12252646” 部落格，請務必保留此出處http://12262646.blog.51cto.com/12252646/1947183

mysql-5.6.17編譯安裝指令碼