Shell-Mysql数据库一键部署

#!/bin/bash

echo "卸载rpm安装的mysql"

rpm -q mysql &> /dev/null

if [ $? -eq 0 ]

then

  rpm -e --nodeps mysql &> /dev/null

fi

rpm -q mysql-server &> /dev/null

if [ $? -eq 0 ]

then

  rpm -e --nodeps mysql-server &> /dev/null

fi

echo "配置本地yum源"

rm -rf /etc/yum.repos.d/*

mkdir /media/cdrom

mount /dev/cdrom /media/cdrom &> /dev/null

echo "[local]" >> /etc/yum.repos.d/local.repo

echo "name=haha" >> /etc/yum.repos.d/local.repo

echo "baseurl=file:///media/cdrom" >> /etc/yum.repos.d/local.repo

echo "enabled=1" >> /etc/yum.repos.d/local.repo

echo "gpgcheck=0" >> /etc/yum.repos.d/local.repo

yum -y install ncurses-devel &> /dev/null

echo "安装cmake"

tar -zxf /root/cmake-2.8.6.tar.gz &> /dev/null

cd /root/cmake-2.8.6

./configure &> /dev/null

gmake &> /dev/null

gmake install &> /dev/null

groupadd mysql

useradd -M -s /sbin/nologin mysql -g mysql

echo "安装mysql，解压ing"

tar -zxf /root/mysql-5.5.22.tar.gz -C /usr/src &> /dev/null

echo "配置ing"

cd /usr/src/mysql-5.5.22

cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DSYSCONFDIR=/etc -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_EXTRA_CHARSETS=all &> /dev/null

echo "编译ing"

make &> /dev/null

echo "安装ing"

make install &> /dev/null

chown -R mysql:mysql /usr/local/mysql/

rm -rf /etc/my.cnf

cd /usr/src/mysql-5.5.22/

cp support-files/my-medium.cnf /etc/my.cnf

echo "初始化数据库"

/usr/local/mysql/scripts/mysql_install_db --user=mysql  --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data/ &> /dev/null

echo "PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile

. /etc/profile

cp support-files/mysql.server /etc/rc.d/init.d/mysqld

chmod +x /etc/rc.d/init.d/mysqld

chkconfig --add mysqld

service mysqld start

if [ $? -eq 0 ]

then

  echo "mysql已正确安装，服务已启动"

else

  echo "mysql服务未启动"

fi

新建.sh 复制粘贴 执行脚本即可