.目錄規(guī)劃：程序目錄：/usr/local/mysql數(shù)據(jù)目錄：/data/mysqlPID和SOCKET文件位置：/tmp.文件下載：官方默認(rèn)只提供最新版本的，歷史版本的下載地址：https://downloads.mysql.com/archives/.7.22版本下載：# wget https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz文件下載大小約614M。#tar -xzf mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz -C /usr/local/#mv /usr/local/mysql-5.7.22-linux-glibc2.12-x86_64/ /usr/local/mysql# echo "export PATH=$PATH:/usr/local/mysql/bin" >/etc/profile.d/mysql.sh# source /etc/profile.d/mysql.sh.創(chuàng)建用戶和授權(quán)：#useradd mysql#passwd mysql#mkdir -p /data/mysql#chown -R mysql:mysql /data/mysql#chmod -R 755 /data/mysql.設(shè)置參數(shù)：[mysqld]#basic#skip-grant-tables #validate_password        =OFFdatadir             = /data/mysqlport              = 3306pid-file            = /tmp/mysql.pidsocket             = /tmp/mysql.socklog_error            = error.logslow-query-log         = 1slow-query-log-file      = slow.loglong_query_time        = 0.2log-bin            = mysql_bin.logbinlog_format         = ROWexpire-logs-days        = 1relay-log           = mysql_relay.logrelay_log_recovery       = 1general_log          = ongeneral_log_file        = general.loglower_case_table_names     = 1server-id            = 1character_set_client_handshake = FALSEcharacter_set_server      = utf8mb4collation_server        = utf8mb4_unicode_ciinit_connect          ='SET NAMES utf8mb4'interactive_timeout       = 172800wait_timeout          = 172800max_prepared_stmt_count     =1048576 max_connections         = 8000#connections max_connections=4000 key_buffer_size=200M low_priority_updates=1 table_open_cache = 8000 back_log=1500 query_cache_type=0 table_open_cache_instances=16#files innodb_file_per_table =on innodb_log_file_size=1024M innodb_log_files_in_group = 3 innodb_open_files=4000#buffersinnodb_buffer_pool_size=1Ginnodb_buffer_pool_instances=32#innodb_additional_mem_pool_size=20Minnodb_log_buffer_size=64Mjoin_buffer_size=32Ksort_buffer_size=32K#innodbinnodb_checksums=0innodb_doublewrite=0innodb_support_xa=0innodb_thread_concurrency=0innodb_flush_log_at_trx_commit=2innodb_max_dirty_pages_pct=50innodb_use_native_aio=1innodb_stats_persistent = 1#innodb_spin_wait_delay= 6 / 96#performanceinnodb_adaptive_flushing = 1innodb_flush_neighbors = 0innodb_read_io_threads = 4innodb_write_io_threads = 4innodb_io_capacity = 4000innodb_purge_threads=1innodb_adaptive_hash_index=0#monitorinnodb_monitor_enable = '%'performance_schema=OFF[mysql]user = root.初始化數(shù)據(jù)庫實(shí)例：/usr/local/mysql/bin/mysqld --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql --initialize-insecure.啟動：# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql# /etc/init.d/mysql startStarting MySQL... SUCCESS! .驗(yàn)證和設(shè)置遠(yuǎn)程訪問：[root@node1 soft]# mysql -p -S /tmp/mysql.sockmysql> grant all privileges on *.* to root@'%' identified by 'oracle' with grant option;Query OK, 0 rows affected, 1 warning (0.01 sec)mysql> flush privileges;Query OK, 0 rows affected (0.00 sec)

update mysql.user set authentication_string=password('newpwd'),password_expired='N' where user='root';

-- 開啟遠(yuǎn)程連接權(quán)限grant all on *.* to root@'%' identified by 'newpwd' with grant option;flush privileges;