美文网首页
MySQL 5.7原生通用二进制格式安装包安装过程

MySQL 5.7原生通用二进制格式安装包安装过程

作者: 丿SunnyR你這暱稱有點意思 | 来源:发表于2019-05-07 21:03 被阅读0次

    [TOC]

    官方文档

    文件说明

    Directory Contents of Directory
    bin mysqld server, client and utility programs
    docs MySQL manual in Info format
    man Unix manual pages
    include Include (header) files
    lib Libraries
    share Error messages, dictionary, and SQL for database installation
    support-files Miscellaneous support files
    shell> groupadd mysql
    shell> useradd -r -g mysql -s /bin/false mysql
    shell> cd /usr/local
    shell> tar zxvf /path/to/mysql-VERSION-OS.tar.gz
    shell> ln -s full-path-to-mysql-VERSION-OS mysql
    shell> cd mysql
    shell> mkdir mysql-files
    shell> chown mysql:mysql mysql-files
    shell> chmod 750 mysql-files
    shell> bin/mysqld --initialize --user=mysql 
    shell> bin/mysql_ssl_rsa_setup              
    shell> bin/mysqld_safe --user=mysql &
    # Next command is optional
    shell> cp support-files/mysql.server /etc/init.d/mysql.server
    

    为了方便,建立了以下一系列shell命令(不敢妄称脚本),当然,也就固化了安装目录为/usr/local/mysql/,数据文件位置/data。请根据需要修改或是直接拍命令。

    [root@CentOS712 ~]# vim MySQL_install.sh 
    
      3 # Date:     07-05-2019
      4 # Comment:  install mysql 5.7.26 on el7
      5 #********************
      6 
      7 function precheck(){
      8     if [ `cat /etc/system-release | awk -F'.' '{print $1}' | cut -d ' ' -f4` -eq 7 ];then
      9         echo -e "Your system os is version 7......Succeed!\n"
     10     else if [ `cat /etc/system-release | awk -F'.' '{print $1}' | cut -d ' ' -f4` -eq 6 ];then
     11         echo -e "Your system os is version 6......Failed!\nThis check is vital, quit forcely!\n"
     12         exit 1
     13         fi
     14     fi
     15 }
     16 
     17 function process(){
     18     echo -e "\n Processing......\n"
     19     useradd -r -u 600 mysql
     20     mkdir /data
     21     chown -R mysql. /data
     22     tar -zxvf $1 -C /usr/local/
     23     local var_one=`ls /usr/local/ | grep mysql`
     24     ln -s /usr/local/${var_one} /usr/local/mysql
     25     chown -R mysql. /usr/local/mysql
     26     chown -R mysql. /usr/local/${var_one}
     27     /usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data
     28     cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
     29     sed -i '45,48s/basedir=/&\/usr\/local\/mysql/' /etc/init.d/mysqld
     30     sed -i '45,48s/datadir=/&\/data/' /etc/init.d/mysqld
     31     echo "export PATH=\$PATH:/usr/local/mysql/bin" >> /etc/profile.d/mysql_env.sh
     32     . /etc/profile.d/mysql_env.sh
     33     echo -e "\n Processing Down"
     34 }
     35 
     36 
     37 precheck
     38 process $1
    "MySQL_install.sh" 38L, 1272C  
    
    

    用法: ./MySQL_install.sh mysql-5.7.26-el7-x86_64.tar.gz

    终端会显示临时密码

    然后

    [root@rhel] service mysqld start
    [root@CentOS712 ~]# mysql -uroot -p
    Enter password: 键入临时密码
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 3
    Server version: 5.7.26 MySQL Community Server (GPL)
    
    Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
    
    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be trademarks of their respective
    owners.
    
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
    mysql> set password=password('123456');
    Query OK, 0 rows affected, 1 warning (0.00 sec)
    
    mysql> \q
    Bye
    

    相关文章

      网友评论

          本文标题:MySQL 5.7原生通用二进制格式安装包安装过程

          本文链接:https://www.haomeiwen.com/subject/ofxuoqtx.html