• mysql install script under the OS of Ubuntu


    #!/bin/bash
    echo "-----------------------start install mysql----------------------"
    apt-get install make cmake libncurses5-dev bison g++
    mkdir -p /data/mysql/dbdata
    if [ `grep "mysql" /etc/passwd | wc -l` -eq 0 ];then
    echo "adding user mysql"
    groupadd mysql
    useradd -g mysql mysql -s /bin/false
    else
    echo "mysql user is exist"
    fi

    wget http://downloads.mysql.com/archives/MySQL-5.6/mysql-5.6.23.tar.gz
    echo "tar xzvf mysql-5.6.23.tar.gz"
    tar xzvf mysql-5.6.23.tar.gz
    cd mysql-5.6.23
    echo "cmake mysql,please wait-----------------"
    cmake '-DCMAKE_INSTALL_PREFIX=/usr/local/mysql' '-DSYSCONFDIR=/etc' '-DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock' '-DDEFAULT_CHARSET=utf8' '-DDEFAULT_COLLATION=utf8_general_ci' '-DEXTRA_CHARSETS=all' '-DWITH_MYISAM_STORAGE_ENGINE=1' '-DWITH_INNOBASE_STORAGE_ENGINE=1' '-DWITH_MEMORY_STORAGE_ENGINE=1' '-DWITH_READLINE=1' '-DENABLED_LOCAL_INFILE=1' '-DMYSQL_DATADIR=/data/mysql/dbdata' '-DMYSQL_USER=mysql' '-DWITH_DEBUG=0'

    if [ $? -ne 0 ];then
    echo "configure failed ,please check it out!"
    exit 1
    fi

    echo "make mysql, please wait for 20 minutes"
    make && make install
    if [ $? -ne 0 ];then
    echo "make failed ,please check it out!"
    exit 1
    fi

    make install

    chown -R mysql:mysql /usr/local/mysql
    chown -R mysql.mysql /data/mysql/dbdata/

    cp ./support-files/my-default.cnf /etc/my.cnf
    cp ./support-files/mysql.server /etc/init.d/mysqld
    chmod 755 /etc/init.d/mysqld

    ln –s /usr/local/mysql/bin/mysql /usr/bin
    ln –s /usr/local/mysql/bin/mysqladmin /usr/bin

    echo "init mysql,please wait-----------------"

    /usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --skip-name-resolve --user=mysql

    if [ $? -ne 0 ];then
    echo "inti failed ,please check it out!"
    exit 1
    fi

    echo "mysql starting"
    /etc/init.d/mysqld start
    if [ $? -ne 0 ];then
    echo "mysql start filed ,please check it out!"
    else
    echo "mysql start successful,congratulations!"
    fi

    版权所有@chrisDuan 博客地址http://www.cnblogs.com/chrisDuan 可以转载,注明出处.
  • 相关阅读:
    EasyNVR加密机授权后,通道和设备信息变为空白的解决办法
    EasySearcher搜索不到EasyNVR硬件的IP地址,如何解决?
    中间件未授权总结
    tomcat漏洞汇总
    weblogic漏洞汇总
    CF573EBear and Bowling【dp,平衡树】
    P4229某位歌姬的故事【dp】
    2109. 向字符串添加空格
    630. 课程表 III 贪心
    Flink官方文档学习(三):Standalone Cluster 集群部署 kylin
  • 原文地址:https://www.cnblogs.com/chrisDuan/p/4476368.html
Copyright © 2020-2023  润新知