• 企业400电话
  • 微网小程序
  • AI电话机器人
  • 电商代运营
  • 全 部 栏 目

    企业400电话 网络优化推广 AI电话机器人 呼叫中心 网站建设 商标✡知产 微网小程序 电商运营 彩铃•短信 增值拓展业务
    Centos7安装 mysql5.6.29 shell脚本

    本文实例为大家分享了mysql5.6.29的shell脚本,供大家参考,具体内容如下

    创建脚本mysql.sh,直接运行sh mysql.sh

    #!/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\]/a\log-error=\/usr\/local\/mysql\/log\/error.log' /usr/local/mysql/my.cnf
    #sed -i '/\[mysqld\]/a\log=\/usr\/local\/mysql\/log\/log' /usr/local/mysql/my.cnf
    #sed -i '/\[mysqld\]/a\log-slow-queries=\/usr\/local\/mysql\/log\/slowquery.log' /usr/local/mysql/my.cnf
    sed -i '/\[mysqld\]/a\long_query_time=2' /usr/local/mysql/my.cnf
    sed -i '/\[mysqld\]/a\pid-file=\/usr\/local\/mysql\/data\/mysql.pid' /usr/local/mysql/my.cnf
    sed -i '/\[mysqld\]/a\character-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
    

    以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持脚本之家。

    您可能感兴趣的文章:
    • CentOS7 64位下MySQL5.7安装与配置教程
    • CentOS 7安装MySQL的详细步骤
    • CentOS7安装mysql5.7解压缩版简明教程
    • Centos7安装和配置Mysql5.7
    • CentOS6.9下mysql 5.7.17安装配置方法图文教程
    • Linux下Centos7安装Mysql5.7.19的详细教程
    • centos7安装mysql5.6的方法
    • CentOS 7安装Mysql并设置开机自启动的方法
    • CentOS 7安装MySQL 8.0.26的过程
    上一篇:Mysql数据库表定期备份的实现详解
    下一篇:MySQL慢查询之开启慢查询
  • 相关文章
  • 

    © 2016-2020 巨人网络通讯 版权所有

    《增值电信业务经营许可证》 苏ICP备15040257号-8

    Centos7安装 mysql5.6.29 shell脚本 Centos7,安装,mysql5.6.29,shell,