環(huán)境

系統(tǒng)：CentOS 6.6
軟件：mysql-5.6.36.tar.gz

mysql安裝

• 下載源碼包
  地址：https://downloads.mysql.com/archives/community/

• 創(chuàng)建mysql用戶(hù)

  # useradd mysql
  

• 安裝依賴(lài)包

  # yum -y install autoconf automake cmake gcc-c++ libgcrypt libtool libxml2 ncurses-devel zlib
  

• 編譯安裝

  # tar -xzvf mysql-5.6.36.tar.gz
  # cd mysql-5.6.36
  
  # cmake \
  -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
  -DDEFAULT_CHARSET=utf8 \
  -DDEFAULT_COLLATION=utf8_general_ci \
  -DENABLED_LOCAL_INFILE=1 \
  -DMYSQL_DATADIR=/data/mysql/data \
  -DSYSCONFDIR=/etc \
  -DWITH_PARTITION_STORAGE_ENGINE=1
  
  # make
  # make install
  

• 配置環(huán)境變量

  # vim /etc/profile
  export PATH=/usr/local/mysql/bin:$PATH
  
  # source /etc/profile
  

mysql配置

• 配置my.cnf

  # vim /etc/my.cnf
  [mysqld_safe]
  log-error=/data/mysql/log/mysql.err
  
  [mysqld]
  datadir=/data/mysql/data
  tmpdir=/data/mysql/tmp
  socket=/var/lib/mysql/mysql.sock
  user=mysql
  
  character_set_server=utf8
  
  default-storage-engine=INNODB
  innodb_buffer_pool_size=1G
  
  slow_query_log=1
  slow_query_log_file=/data/mysql/log/mysql.slow
  long_query_time=2
  
  server_id=1
  log-bin=/data/mysql/log-bin/log-bin
  binlog_format=row
  
  max_connections=1000
  
  [client]
  socket=/var/lib/mysql/mysql.sock
  

• 創(chuàng)建所需目錄

  # mkdir -p /data/mysql/data
  # mkdir -p /data/mysql/log
  # mkdir -p /data/mysql/log-bin
  # mkdir -p /data/mysql/tmp
  
  # mkdir /var/lib/mysql
  

• 創(chuàng)建所需文件

  # touch /data/mysql/log/mysql.err
  

• 改變屬主和屬組

  # chown -R mysql:mysql /data/mysql
  # chown -R mysql:mysql /var/lib/mysql
  # chown -R mysql:mysql /usr/local/mysql
  

• 執(zhí)行初始化配置腳本

  # cd /usr/local/mysql
  # ./scripts/mysql_install_db --user=mysql --datadir=/data/mysql/data
  

mysql啟動(dòng)

• 啟動(dòng)

  # cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
  # chkconfig --add mysqld
  # chkconfig mysqld on
  # service mysqld restart
  

• 運(yùn)行安全配置向?qū)?/p>

  # ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
  # mysql_secure_installation
  Enter current password for root (enter for none):
  新安裝mysql無(wú)root密碼，按Enter即可
  Set root password? [Y/n] Y
  Remove anonymous users? [Y/n] Y
  Disallow root login remotely? [Y/n] n
  Remove test database and access to it? [Y/n] Y
  Reload privilege tables now? [Y/n] Y