mysql编译脚本
#!/bin/bash#系统版本RHEL6.3，mysql5.6
yum-y install ncurses-devel
useradd -r mysql -s /sbin/nologin
pwd=`pwd`
#解压mysql5.6的源码包
if [ -f $pwd/mysql-5.6.31.tar.gz ]
then
echo "mysql已下载"
else
wget https://cdn.mysql.com/archives/mysql-5.6/mysql-5.6.31.tar.gz
fi
if [ -f$pwd/cmake-3.6.3.tar.gz ]
then
echo "cmake已下载"
else
wget --no-check-certificate https://cmake.org/files/v3.6/cmake-3.6.3.tar.gz
fi
tar xf $pwd/mysql-5.6.31.tar.gz -C /usr/local/src/
#解压cmake-2.8.5的源码包
tar xf $pwd/cmake-3.6.3.tar.gz -C /usr/local/src/
#编译cmake
cd /usr/local/src/cmake-3.6.3/
./configure && make && make install
#编译mysql5.6
cd ../mysql-5.6.31/
cmake . -DCMAKE_INSTALL_PREFIX=/opt/mysql5.6 \
-DMYSQL_DATADIR=/data \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DMYSQL_UNIX_ADDR=/tmp/mysql.sock \
-DENABLED_LOCAL_INFILE=1 \
-DEXTRA_CHARSETS=all \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci
make && make install
#修改mysql目录属组
cd /opt/mysql5.6/
chown mysql.mysql -R .
mkdir /data
chown mysql.mysql /data
#移除系统默认的配置文件
if [ -z /etc/my.cnf.bak ]
then
mv /etc/my.cnf /etc/my.cnf.bak
fi
#修改配置文件
cat>/etc/my.cnf
页:
[1]