MySQL安装脚本只需执行即可安装

MySQL安装脚本只需执行即可安装

第一：下载好你需要安装的数据库
第二：配置好你的yum源，如果是CentOS那么则无需配置yum源了
第三：将你下载好的mysql-XXX.tar以及脚本放入/usr/local/src目录下
第四：执行该脚本
在一台已经安装好的centos6以上版本或者RedHat6以上版本上执行脚本 将附件改名成installmysql.sh（要以.sh结尾为好）
bash installmysql.sh
会出现提示 那么请输入你的版本如下图

第五：启动你的mysql数据库 service mysqld start
脚本内容如下：

#!/bin/bash
export PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/mysql/bin:/root/bin:/usr/local/mysql/bin
DATE=`date "+%Y%m%d %H:%M:%S"`
MYSQL_DIR=/usr/local/mysql
DATA_DIR=/data/mysql/data
CHECKINSTALL="is not installed"
RPMLIST="make gcc gcc-c++  autoconf automake  bison  ncurses-devel libtool-ltdl-devel* cmake"
TAR=/usr/local/src
cat >>/etc/profile <<EOF
export PATH=$PATH:/usr/local/mysql/bin
EOF
source /etc/profile
cp -a /etc/profile  /etc/profile.bak
read -p "please enter you mysql version (eg:/mysql-5.5.34):" BANBEN
echo 执行完该脚本启动你的MYSQL并在/etc/profile文件里写入并source执行这样才能直接使用mysql命令 export PATH=$PATH:/usr/local/mysql/bin
sleep 1
echo  '装包部分开始'
sleep 1
rpm -qa |grep mysql  > /tmp/mysqlremove.txt
if [ $? -eq 0 ];then
for i in $(cat /tmp/mysqlremove.txt); do yum -y remove $i; done
echo ""
echo -e "$DATE \033[32m MYSQL already removed \033[0m" >> /tmp/tarmysql.log
echo ""
else
echo -e "$DATE \033[32m MYSQL does not exist \033[0m"  >> /tmp/tarmysql.log
fi
rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' gcc gcc-c++  autoconf automake  bison  ncurses-devel libtool-ltdl-devel cmake > /tmp/rpmtoolinstall.log
grep 'is not install' /tmp/rpmtoolinstall.log
if [ $? -eq  0 ];then
 yum -y install $RPMLIST
else
echo -e "$DATE \033[32m MYSQL tool already install \033[0m"  >> /tmp/mysqltool.log
fi
echo '创建mysql相关目录开始'
sleep 1
if [ ! -d /usr/local/mysql ];then
mkdir /usr/local/mysql -p
else
echo '/usr/local/mysql already having'    >> /tmp/tarmysql.log
fi
if [ ! -d /data/mysql/data ];then
mkdir /data/mysql/data -p
else
echo /data/mysql/data already having    >> /tmp/tarmysql.log
fi
echo '创建mysql相关用户和组开始'
sleep 1
grep mysql /etc/group &>/dev/null
if [ $? -eq 0 ];then
echo "group:mysql is already exist"    >> /tmp/tarmysql.log
else
groupadd mysql
fi
grep mysql /etc/passwd &>/dev/null
if [ $? -eq 0 ];then
echo 'user:mysql is already exist'    >> /tmp/tarmysql.log
else
useradd -g mysql mysql
fi
chown mysql.mysql -R /usr/local/mysql/
echo '解压部分开始'
sleep 1
if [ ! -d $TAR/$BANBEN ];then
tar -xf  $TAR/$BANBEN.tar.gz
else
echo  'tar -xf already ----> ok'
echo 'tar -xf already ----> ok'    >> /tmp/tarmysql.log
fi
if [ -d $TAR/$BANBEN ];then
cd $TAR/$BANBEN
else
echo  "没有包装数据库,not having mysql-tar,,请把你下载的mysql的tar包放在/usr/local/src目录下再执行"
sleep 2
exit 20
fi
echo '重头戏装包开始'
sleep 1
if [ -f $TAR/$BANBEN/CMakeCache.txt ];
then
echo 你已经装好了一个数据库顶多是没有执行 请先启动正常使用如有问题执行 ./mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql/data --skip-grant-tables --skip-networking /usr/local/mysql/scripts/执行上一条命令如果还是不行请删除你现有的数据库再执行该脚本
exit 21
else
cd $TAR/$BANBEN
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_UNIX_ADDR=/tmp/mysql.sock \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DWITH_EXTRA_CHARSETS:STRING=all \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_FEDERATED_STORAGE_ENGINE=1 \
-DWITH_EXAMPLE_STORAGE_ENGINE=1 \
-DMYSQL_DATADIR=/data/mysql/data \
-DMYSQL_USER=mysql \
-DMYSQL_TCP_PORT=3306
sleep 1
echo 'start make'
sleep 1
make
sleep 2
echo 'start make install'
sleep 1
make install
fi
/usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql/data --skip-grant-tables --skip-networking
cp /usr/local/mysql/support-files/my-default.cnf
cp /usr/local/mysql/support-files/my-small.cnf /etc/my.cnf
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
export PATH=$PATH:/usr/local/mysql/bin
chmod +x /etc/init.d/mysqld
chkconfig --add mysqld
chkconfig mysqld on
chown mysql.mysql /usr/local/mysql -R
sleep 1
echo "请你手动启动数据库 service mysqld start 给你的数据库设置密码谢谢使用"