一、安裝環境：

  操作系統：Ubuntu16.04

  數據庫：MySQL-5.7.17-linux-glibc2.5-x86_64 （免安裝版）

二、解壓

  tar -xzvf mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz

  mv mysql-5.7.17-linux-glibc2.5-x86_64   /usr/local/mysql

三、增加用戶和組

  groupadd mysql;

  useradd -g mysql mysql;

四、創建目錄及目錄權限：

  mkdir /mysql /mysql/data /mysql/log

  修改目錄權限

   chown -R mysql:mysql /usr/local/mysql /mysql五、在/etc目錄下創建文件：my.cnf
  直接使用 vi my.cnf創建
[client]port = 3306socket = /tmp/mysql.sock[mysqld]server_id=10port = 3306user = mysqlsocket = /tmp/mysql.sockbasedir = /usr/local/mysqldatadir = /mysql/datapid-file = /mysql/data/mysql.pidmax_connections = 1000max_connect_errors = 1000table_open_cache = 1024max_allowed_packet = 128Mopen_files_limit = 65535#####====================================[innodb]==============================innodb_buffer_pool_size = 1024Minnodb_file_per_table = 1innodb_write_io_threads = 4innodb_read_io_threads = 4innodb_purge_threads = 2innodb_flush_log_at_trx_commit = 1innodb_log_file_size = 512Minnodb_log_files_in_group = 2innodb_log_buffer_size = 16Minnodb_max_dirty_pages_pct = 80innodb_lock_wait_timeout = 30innodb_data_file_path=ibdata1:1024M:autoextend#####====================================[log]==============================log_error = /mysql/log/mysql-error.log slow_query_log = 1long_query_time = 1 slow_query_log_file = /mysql/log/mysql-slow.logsql_mode=ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
六、初始化數據庫及配置
  注意：5.7.6之后的版本初始化數據庫不再使用mysql_install_db
  bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/mysql/data  --innodb_undo_tablespaces=3 --explicit_defaults_for_timestamp
 如果配置了my.cnf的log_error，那么初始密碼在log_error文件中，否則會打印出來。
  bin/mysql_ssl_rsa_setup --datadir=/mysql/data
  修改目錄權限
 chown -R mysql:mysql /usr/local/mysql /mysql
  配置啟動文件
 cp support-files/mysql.server /etc/init.d/mysql
  配置環境變量
  mysql_home=/usr/local/mysql  PATH=$PATH:$mysql_home/bin
七、配置數據庫密碼及遠程訪問：
  使用初始化密碼進行登錄：
  密碼存儲在日志文件中：sudo vi mysql-error.log
  mysql -u root -p ******* 
 初次使用，設置root密碼：   SET PASSWord=PASSWORD('root');  然后才可以使用和操作數據庫進行修改：
   update mysql.user set authentication_string=password('root') where user='root';
  修改遠程訪問權限
       mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root_password' WITH GRANT OPTION;       mysql> FLUSH PRIVILEGES ;八、ubuntu下增加mysql到系統默認啟動
  sudo update-rc.d mysql defaults