【安装】
#!/bin/bash
MYSQL_HOME=/usr/local/mysql
# 将你的mysql安装程序解压后的文件名设置为MYSQL_DIR,将安装程序(mysql-xxx.tar.gz)放到当前目录
MYSQL_DIR=mysql-standard-5.0.20-linux-i686-glibc23
MYSQL_DIR_OLD=$PWD/${MYSQL_DIR}
MYSQL_DIR_NEW=/usr/local/${MYSQL_DIR}
MYSQL_SOURCE=$MYSQL_DIR_OLD.tar.gz
if [ ! -f ${MYSQL_SOURCE} ]
then
echo "MySQL package not found!"
exit 1
fi
id mysql > /dev/null 2>&1
if [ $? -eq 1 ]
then
# If user mysql does not exist,
# delete group mysql fisrt if exists
sed -i '/^mysql/d' /etc/group
echo "Add group mysql"
groupadd mysql
echo "Add user mysql"
useradd -g mysql mysql
fi
echo "Unzip MySQL-5.0.20"
tar zxvf ${MYSQL_SOURCE} > /dev/null 2>&1
echo "Move MySQL to the right place"
mv ${MYSQL_DIR_OLD} ${MYSQL_DIR_NEW}
echo "Create mysql linkage"
ln -s ${MYSQL_DIR_NEW} ${MYSQL_HOME}
echo "Change mysql directory to the right user and group"
cd $MYSQL_HOME
chown -R root .
cd $MYSQL_HOME
chown -R mysql data
cd $MYSQL_HOME
chgrp -R mysql .
echo "Create mysql system database"
$MYSQL_HOME/scripts/mysql_install_db --user=mysql > /dev/null
echo "Set environment PATH"
sed -i '/export PATH=\/usr\/local\/mysql\/bin:$PATH/d' /etc/profile
echo 'export PATH=/usr/local/mysql/bin:$PATH' >> /etc/profile
. /etc/profile
echo "Set mysql as system service"
cp $MYSQL_HOME/support-files/mysql.server /etc/init.d/mysql
chkconfig mysql on
/etc/init.d/mysql start
echo -n "Please input password of mysql user root: "
stty -echo
read ROOT_PASSWORD
stty echo
echo
if [ -z $ROOT_PASSWORD ]
then
echo "ERROR: The password is null!"
exit 1
fi
mysqladmin -uroot password "$ROOT_PASSWORD"
mysql -uroot -p$ROOT_PASSWORD -e"grant all on *.* to root@localhost identified by '$ROOT_PASSWORD'"
if [ $? -eq 0 ]
then
echo "Set mysql user root password successfully!"
fi
【卸载】
<pre name="code" class="plain">#!/bin/bash
MYSQL_HOME=/usr/local/mysql
# 将你的mysql安装程序解压后的文件名设置为MYSQL_DIR
MYSQL_DIR=mysql-standard-5.0.20-linux-i686-glibc23
MYSQL_DIR_NEW=/usr/local/${MYSQL_DIR}
echo "Kill mysql demon"
pkill mysql > /dev/null 2>&1
echo "Clean mysql from PATH"
sed -i '/export PATH=\/usr\/local\/mysql\/bin:$PATH/d' /etc/profile
chkconfig mysql off
rm -f /etc/init.d/mysql
rm -f /etc/rc2.d/*mysql
rm -f /etc/rc3.d/*mysql
rm -f /etc/rc4.d/*mysql
rm -f /etc/rc5.d/*mysql
rm -f /etc/rc6.d/*mysql
echo "Remove mysql source file"
rm -rf ${MYSQL_HOME}
rm -rf ${MYSQL_DIR_NEW}
echo "Remove user mysql"
sed -i '/^mysql/d' /etc/group
sed -i '/^mysql/d' /etc/passwd