mysql5.5一键安装脚本

<span style="background-color: rgb(255, 255, 255);"><span style="font-family: 'Microsoft Yahei', Tahoma, Helvetica, SimSun, sans-serif; font-size: 14px; line-height: 21px; ">环境：centos5.6+mysql-5.5.37                     mysql5.5以后都用cmake编译，需要安装cmake</span><br style="word-wrap: break-word; font-family: 'Microsoft Yahei', Tahoma, Helvetica, SimSun, sans-serif; font-size: 14px; line-height: 21px; " /><span style="font-family: 'Microsoft Yahei', Tahoma, Helvetica, SimSun, sans-serif; font-size: 14px; line-height: 21px; ">因为mysql环境包蛮多，我们需要指定yum源。为了不影响网速我用的本地yum源，用163或官方yum源也是可以的</span><br style="word-wrap: break-word; font-family: 'Microsoft Yahei', Tahoma, Helvetica, SimSun, sans-serif; font-size: 14px; line-height: 21px; " /><span style="word-wrap: break-word; font-family: 'Microsoft Yahei', Tahoma, Helvetica, SimSun, sans-serif; font-size: 14px; line-height: 21px; "><span style="font-family:宋体;word-wrap: break-word; ">安装目录：/usr/local/mysql/</span></span><br style="word-wrap: break-word; font-family: 'Microsoft Yahei', Tahoma, Helvetica, SimSun, sans-serif; font-size: 14px; line-height: 21px; " /><span style="word-wrap: break-word; font-family: 'Microsoft Yahei', Tahoma, Helvetica, SimSun, sans-serif; font-size: 14px; line-height: 21px; "><span style="font-family:宋体;word-wrap: break-word; ">数据目录：/data/mysql/data/</span></span><br style="word-wrap: break-word; font-family: 'Microsoft Yahei', Tahoma, Helvetica, SimSun, sans-serif; font-size: 14px; line-height: 21px; " /><span style="word-wrap: break-word; font-family: 'Microsoft Yahei', Tahoma, Helvetica, SimSun, sans-serif; font-size: 14px; line-height: 21px; "><span style="font-family:宋体;word-wrap: break-word; ">二进制日志：/data/msyql/binlog/</span></span><br style="word-wrap: break-word; font-family: 'Microsoft Yahei', Tahoma, Helvetica, SimSun, sans-serif; font-size: 14px; line-height: 21px; " /><span style="word-wrap: break-word; font-family: 'Microsoft Yahei', Tahoma, Helvetica, SimSun, sans-serif; font-size: 14px; line-height: 21px; "><span style="font-family:宋体;word-wrap: break-word; ">relay日志：/data/mysql/relaylog/</span></span><br style="word-wrap: break-word; font-family: 'Microsoft Yahei', Tahoma, Helvetica, SimSun, sans-serif; font-size: 14px; line-height: 21px; " /><span style="word-wrap: break-word; font-family: 'Microsoft Yahei', Tahoma, Helvetica, SimSun, sans-serif; font-size: 14px; line-height: 21px; "><span style="font-family:宋体;word-wrap: break-word; ">配置文件：/data/mysql/my.cnf</span></span><br style="word-wrap: break-word; font-family: 'Microsoft Yahei', Tahoma, Helvetica, SimSun, sans-serif; font-size: 14px; line-height: 21px; " /><span style="word-wrap: break-word; font-family: 'Microsoft Yahei', Tahoma, Helvetica, SimSun, sans-serif; font-size: 14px; line-height: 21px; "><span style="font-family:宋体;word-wrap: break-word; ">mysql.sock文件：/data/mysql/mysql.sock</span></span><br style="word-wrap: break-word; font-family: 'Microsoft Yahei', Tahoma, Helvetica, SimSun, sans-serif; font-size: 14px; line-height: 21px; " /><span style="font-family: 宋体; word-wrap: break-word; font-size: 14px; line-height: 21px; "><span style="word-wrap: break-word; "><span style="word-wrap: break-word; ">1、将cmake和mysql源码包弄到 /data/soft 目录内，配置好yum源</span></span></span><br style="word-wrap: break-word; font-family: 'Microsoft Yahei', Tahoma, Helvetica, SimSun, sans-serif; font-size: 14px; line-height: 21px; " /><span style="word-wrap: break-word; font-family: 'Microsoft Yahei', Tahoma, Helvetica, SimSun, sans-serif; font-size: 14px; line-height: 21px; "><span style="font-family:宋体;word-wrap: break-word; ">cmake下载地址    </span></span><span style="font-family: 宋体; word-wrap: break-word; font-size: 14px; line-height: 21px; "><span style="word-wrap: break-word; ">http://www.cmake.org/files/v2.8/cmake-2.8.12.2.tar.gz</span></span><br style="word-wrap: break-word; font-family: 'Microsoft Yahei', Tahoma, Helvetica, SimSun, sans-serif; font-size: 14px; line-height: 21px; " /><span style="font-family: 宋体; word-wrap: break-word; font-size: 14px; line-height: 21px; "><span style="word-wrap: break-word; ">mysql下载地址    <a target=_blank href="ftp://mirror.switch.ch/mirror/mysql/Downloads/MySQL-5.5/mysql-5.5.37.tar.gz" target="_blank" class="gj_safe_a" style="word-wrap: break-word; ">ftp://mirror.switch.ch/mirror/my ... mysql-5.5.37.tar.gz</a></span></span></span>

<span style="font-family: 宋体; word-wrap: break-word; font-size: 14px; line-height: 21px; background-color: rgb(255, 255, 255); "></span>

<span style="font-family: 宋体; word-wrap: break-word; font-size: 14px; line-height: 21px; background-color: rgb(255, 255, 255); "><span style="color:#ffffff;"></span></span>

<span style="font-family:宋体;word-wrap: break-word; color: rgb(68, 68, 68); font-size: 14px; line-height: 21px; "></span>

#!/bin/bash#指定源码包目录、mysql数据目录、mysql安装目录MYSQL_DIR="/data/soft"DATA_DIR="/data/mysql/data"BASE_DIR="/usr/local/mysql"echo "please input mysql version:"read VERSIONecho “"Your mysql version is mysql-$VERSION.tar.gz"if [ -e "$MYSQL_DIR/mysql-$VERSION.tar.gz" ]thenecho "Please waitting"sleep 3#Install mysql package dependent.yum -y install gcc gcc-c++ gcc-g77 autoconf openssl zlib* fiex* libxml* ncurses-devel libmcrypt* libtool-ltdl-devel* &&#Install cmakeecho "The system is be install cmakemplease waitting..."sleep 3tar -zxvf $MYSQL_DIR/cmake-2.8.12.2.tar.gz -C $MYSQL_DIR &&cd $MYSQL_DIR/cmake-2.8.12.2 &&./configure --prefix=/usr/local/cmake && make && make install &&#creating mysql account and group/usr/sbin/groupadd mysql &&/usr/sbin/useradd -s /sbin/nologin -g mysql -M mysql &&#Install mysql.tar -zxvf $MYSQL_DIR/mysql-$VERSION.tar.gz -C $MYSQL_DIRcd $MYSQL_DIR/mysql-$VERSIONecho "PATH=$PATH:/usr/local/cmake/bin" >> /etc/profile && source /etc/profile#编译mysql，可以按自己需求编译cmake $MYSQL_DIR/mysql-$VERSION-DCMAKE_INSTALL_PREFIX=/usr/local/mysql-DYSQL_TCP_PORT=3306-DMYSQL_DATADIR=$DATA_DIR-DMYSQL_UNIX_ADDR=/data/mysql/mysql.sock-DWITH_MYISAM_STORAGE_ENGING=1-DWITH_INNOBASE_STORAGE_ENGINE=1  -DDEFAULT_CHARSET=utf8  -DDEFAULT_COLLATION=utf8_general_ci  -DEXTRA_CHARSETS=all -DWITH_DEBUG=0make && make install &&mkdir -p $DATA_DIRmkdir -p `dirname $DATA_DIR`/binlogmkdir -p `dirname $DATA_DIR`/relaylogcp $MYSQL_DIR/mysql-$VERSION/support-files/my-small.cnf.sh `dirname $DATA_DIR`/my.cnfcp $MYSQL_DIR/mysql-$VERSION/support-files/mysql.server.sh /etc/init.d/mysqldchmod +x /etc/init.d/mysqldsed -i 's/^basedir=/basedir=\/usr\/local\/mysql/' /etc/init.d/mysqldsed -i 's/^datadir=/datadir=\/data\/mysql\/data/' /etc/init.d/mysqldsed -i 's/`@HOSTNAME@`/lqx.com/' /etc/init.d/mysqld#初始化mysqlsh /usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=$DATA_DIR  &&/etc/init.d/mysqld startelseecho "Your input mysql version  is not in $MYSQL_DIR"fi

执行脚本一键安装mysql
 

一键安装完成
 

检验
 

KO