• mysql自动安装脚本


    #!/bin/bash
    if [ -d /software ] ;then
    cd /software
    else
    mkdir /software && cd /software
    fi

    #is exist command ,if not,yum install
    is_exist() {
    which $1
    if [ $? -ne 0 ] ;then
    yum -y install $1
    fi
    }

    #dolownad the mysql install package,if exist,check the md5sum,if correct,tar;else rm and download
    if [ -f mysql-5.6.29.tar.gz ] ;then
    mysql_md5=`md5sum mysql-5.6.29.tar.gz | cut -d " " -f 1 `
    mysql_md5_true="aaa21c6450adee3a1894fd1710f02bf5"
    if [ "$mysql_md5" = "$mysql_md5_true" ] ;then
    tar -zxvf mysql-5.6.29.tar.gz
    else
    rm -rf mysql-5.6.29.tar.gz
        rm -rf mysql-5.6.29
    fi
    else
    is_exist wget
    wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.29.tar.gz
    tar -zxvf mysql-5.6.29.tar.gz
    fi

    #see the yum source is use
    yum cleanup
    yum makecache

    #install the depend package
    yum -y install gcc make cmake ncurses-devel libxml2-devel libtool-ltdl-devel gcc-c++ autoconf automake bison zlib-devel

    #add mysql group and user
    is_user_mysql=`cat /etc/passwd |awk -F ":" '{print $1}' |grep mysql`
    is_group_mysql=`cat /etc/group |awk -F ":" '{print $1}' |grep mysql`

    if [ "$is_group_mysql" != "mysql" ] ;then
    groupadd mysql
    fi
    if [ "$is_user_mysql" != "mysql" ] ;then
    useradd -r -s /sbin/nologin -g mysql mysql
    fi

    #compile and install
    cd mysql-5.6.29
    cmake .
    make && make install

    chown -R mysql.mysql /usr/local/mysql

    #init database
    /usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data

    #copy the important file to /etc
    #cp /usr/local/mysql/my.cnf /etc/my.cnf

    sed -i 's/# basedir = ...../basedir = /usr/local/mysql/g' /usr/local/mysql/my.cnf
    sed -i 's/# port = ...../port = 3306/g' /usr/local/mysql/my.cnf
    sed -i 's/# datadir = ...../datadir = /usr/local/mysql/data/g' /usr/local/mysql/my.cnf
    sed -i '/[mysqld]/alog-error=/usr/local/mysql/log/error.log' /usr/local/mysql/my.cnf
    #sed -i '/[mysqld]/alog=/usr/local/mysql/log/log' /usr/local/mysql/my.cnf
    #sed -i '/[mysqld]/alog-slow-queries=/usr/local/mysql/log/slowquery.log' /usr/local/mysql/my.cnf
    sed -i '/[mysqld]/along_query_time=2' /usr/local/mysql/my.cnf
    sed -i '/[mysqld]/apid-file=/usr/local/mysql/data/mysql.pid' /usr/local/mysql/my.cnf
    sed -i '/[mysqld]/acharacter-set-server=utf8' /usr/local/mysql/my.cnf

    echo "[client] " >> /usr/local/mysql/my.cnf
    echo "socket = /var/lib/mysql/mysql.sock" >>/usr/local/mysql/my.cnf

    /usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data
    #use database
    /usr/local/mysql/bin/mysqld_safe --user=mysql &

    cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
    chkconfig --add mysqld
    chkconfig mysqld on

    `ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock`
    #start the service
    service mysqld restart

    #import environment
    PATH=$PATH:/usr/local/mysql/bin
    echo "export PATH=$PATH:/usr/local/mysql/bin >> /etc/profile"
    source /etc/profile

    ##########################################执行脚本前先创建下面文件###############
    #mkdir -p /usr/local/mysql/log
    #touch /usr/local/mysql/log/error.log
    ##################################################################################

    ##############安装完成后如果出现以下问题,附解决方法################
    #mysql命令找不到
    #cd /etc
    #vi profile
    #在最后加
    #export PATH=$PATH:/usr/local/mysql/bin
    ################################################################################

    ###########################mysql配置文件位置#############################
    #/usr/local/mysql/my.cnf
    ################################################################################


    #######################################修改密码#######################################
    #自己在数据库执行
    #UPDATE user SET Password = password ( '自己的密码' ) WHERE User = 'root' ;
    #flush privileges;
    ################################################################################

    纵有白头俱老意,奈何缘浅路芊芊.
  • 相关阅读:
    js 鸭式辨型法
    javascript performence
    js继承实现
    js深入理解构造函数和原型对象
    js 变量类型
    JS 严格模式
    鼠标滚动事件
    css3-transform
    js.map error
    canvas(一) 基本线条绘制
  • 原文地址:https://www.cnblogs.com/hanby/p/15077623.html
Copyright © 2020-2023  润新知