Linux下安装Mysql数据库

    chkconfig iptables off
    
    
      
    
    AI写代码

    tar -zxvf mysql-5.6.45-linux-glibc2.12-x86_64.tar.gz
    
    
      
    
    AI写代码

    mv  mysql-5.6.45-linux-glibc2.12-x86_64 mysql
    
    
      
    
    AI写代码

    cp support-files/my-default.cnf /etc/my.cnf
    
    #创建mysql用户组及用户
    groupadd mysql
    useradd -r -g mysql mysql
    
    
      
      
      
      
      
    
    AI写代码

    # Remove leading # and set to the amount of RAM for the most important data
    # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
    # innodb_buffer_pool_size = 128M
    
    # Remove leading # to turn on a very important data integrity option: logging
    # changes to the binary log between backups.
    # log_bin
    
    # These are commonly set, remove the # and set as required
    basedir = /usr/local/java/mysql5.6
    datadir = /usr/local/java/mysql5.6/data
    port = 3306
    # server_id = .....
    socket = /usr/local/java/mysql5.6/mysql.sock
    character-set-server = utf8 
    log-error=/usr/local/java/mysql5.6/data/error.log 
    pid-file=/usr/local/java/mysql5.6/data/mysqld.pid
    
    
    # Remove leading # to set options mainly useful for reporting servers.
    # The server defaults are faster for transactions and fast SELECTs.
    # Adjust sizes as needed, experiment to find the optimal values.
    # join_buffer_size = 128M
    # sort_buffer_size = 2M
    # read_rnd_buffer_size = 2M
    
    sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
    
    
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
      
    
    AI写代码

    chown -R mysql .
    chgrp -R mysql .
    scripts/mysql_install_db --user=mysql
    chown -R root .
    chown -R mysql data
    
    
      
      
      
      
      
    
    AI写代码

    ./mysql_install_db --verbose --user=root --defaults-file=/etc/my.cnf --datadir=/usr/local/java/mysql5.6/data --basedir=/usr/local/java/mysql5.6 --pid-file=/usr/local/java/mysql5.6/data/mysql.pid --tmpdir=/tmp
    
    
      
    
    AI写代码

    ./mysqld_safe --defaults-file=/etc/my.cnf --socket=/usr/local/java/mysql5.6/mysql.sock --user=root &
    
    
      
    
    AI写代码

    cp /usr/local/java/mysql5.6/support-files/mysql.server /etc/init.d/mysqld
    cp /usr/local/java/mysql5.6/support-files/mysql.server /etc/rc.d/init.d/mysqld
    chmod 700 /etc/init.d/mysql
    chkconfig --add mysqld
    chkconfig --level 2345 mysqld on
    chown mysql:mysql -R /usr/local/java/mysql5.6/
    
    
      
      
      
      
      
      
    
    AI写代码

    reboot
     
    service mysqld status  
    #查看服务状态显示
    MySQL running (1541)                                       [  OK  ]
    
    netstat -na | grep 3306 
    #查看端口号显示
    tcp        0      0 0.0.0.0:3306                0.0.0.0:*                   LISTEN
    
    
      
      
      
      
      
      
      
      
      
    
    AI写代码