mysql的部署

mysql在linux系统中的部署：

　二进制包安装软件：

　　第一步：下载二进制软件，上传到服务器

    www.mysql.com
    mkdir /server/tools -y
    cd /server/tools 
    wget ftp://ftp.jaist.ac.jp/pub/mysql/Downloads/MySQL-5.6/
    rz -y

View Code

　　第二步：解压软件包，并移动到相应的程序目录进行授权

    tar xf mysql-5.6.34-linux-glibc2.5-x86_64.tar.gz
    mv mysql-5.6.34-linux-glibc2.5-x86_64 /application/mysql-5.6.34
    ln -s /application/mysql-5.6.34/ /application/mysql
    useradd mysql -M -s /sbin/nologin
    chown -R mysql.mysql /application/mysql/data/

View Code

　　第三步：初始化mysql程序

　　　/application/mysql/scripts/mysql_install_db --basedir=/application/mysql --datadir=/application/mysql/data/ --user=mysql

　　第四步：启动mysql服务

    cp /application/mysql/support-files/mysql.server /etc/init.d/mysqld
    sed -i 's#/usr/local#/application#g' /etc/init.d/mysqld 
    sed -i 's#/usr/local#/application#g' /application/mysql/bin/mysqld_safe
    cp /application/mysql/support-files/my-default.cnf /etc/my.cnf
    ll /tmp/ -d    --- 权限为1777
    chmod 1777 /tmp
    
    /etc/init.d/mysqld start

View Code

　　第五步：进入到mysql环境中

        /application/mysql/bin/mysql -uroot
    /application/mysql/bin/mysqladmin -uroot password "oldboy123"   --- 设置mysql进入密码
    /application/mysql/bin/mysql -uroot -poldboy123

View Code