mysql-5.6.16装配脚本-MySQL教程-爱易网页

mysql-5.6.16装配脚本

日期：2014-05-16　浏览次数：20962 次

mysql-5.6.16安装脚本
#!/bin/bash
# create by xuekun
# by 2014-3-30
#

# Source function library.
. /etc/rc.d/init.d/functions
# env
SOFT_PATH=/home/xuekun/tools
LOG_PATH=/home/xuekun/install_log_$(date +%Y-%m-%d-%H:%M:%S).log
#
if [ $# -lt 1 ]
then
   action $" running false " /bin/false
   echo "$(basename $0) mysql-5.6.16_download_url"
fi

[ ! -d "${SOFT_PATH}" ] && mkdir -p ${SOFT_PATH}

cd ${SOFT_PATH}

# download mysql-5.6.16.tar.gz
wget $1

tar xvf mysql-5.6.16.tar.gz
cd mysql-5.6.16
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

make && make install

# add mysql user
groupadd mysql
useradd -g mysql mysql

#access
chown -R mysql:mysql /usr/local/mysql
cd /usr/local/mysql
scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql >> ${LOG_PATH}
cp support-files/mysql.server /etc/init.d/mysql
chkconfig mysql on

# check my.cnf
if [ -f "/etc/my.cnf" ]
then
   mv /etc/my.cnf /etc/my.cnf_bak_$(date +%Y%m%d)
fi
# start mysql
service mysql start >> ${LOG_PATH}

# add to /etc/profile
echo "PATH=/usr/local/mysql/bin:\$PATH" >> /etc/profile
echo "export PATH" >> /etc/profile
source /etc/profile

3306_str=$(netstat -lnt|grep "3306")

echo ${3306_str} >>${LOG_PATH}

[ ! -z "nn" ] && action $"mysql-5.6.16 install successful" /bin/true