MySQL 5.7.22 二进制包安装及免安装版Windows配置方法

.目录规划：程序目录：/usr/local/mysql数据目录：/data/mysqlPID和SOCKET文件位置：/tmp.文件下载：官方默认只提供最新版本的，历史版本的下载地址：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.创建用户和授权：#useradd mysql#passwd mysql#mkdir -p /data/mysql#chown -R mysql:mysql /data/mysql#chmod -R 755 /data/mysql.设置参数：[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.初始化数据库实例：/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! .验证和设置远程访问：[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';

-- 开启远程连接权限grant all on *.* to root@'%' identified by 'newpwd' with grant option;flush privileges;