Mysql解压版安装重要信息

Mysql解压版安装重要信息1、my.ini配置信息[client]port=3358socket=E:\MySQL\mysql-5.6.17-winx64\mysql.sock[mysqld]port=3358socket=E:\MySQL\mysql-5.6.17-winx64\mysql.sockbasedir=E:\MySQL\mysql-5.6.17-winx64datadir=E:\MySQL\mysql-5.6.17-winx64\data#---GLOBAL---#character-set-server=utf8lower_case_table_names=1log-output=FILElong_query_time=0.1#sync_binlog=1max_connections=20000######################--------------#thread_concurrency=16thread_cache_size=512table_open_cache=16384table_definition_cache=16384sort_buffer_size=2Mjoin_buffer_size=2Mread_buffer_size=4Mread_rnd_buffer_size=4Mkey_buffer_size=64Mmyisam_sort_buffer_size=64Mtmp_table_size=256Mmax_heap_table_size=256Mopen_files_limit=1024#query_cache_size=2G#---NETWORK---#back_log=1024max_allowed_packet=16Minteractive_timeout=2147483wait_timeout=2147483skip-external-lockingmax-connections=500skip-name-resolve#---REPL---#server-id=20644log-bin=mysql-binbinlog_format=mixedexpire_logs_days=7relay-log=relay-logreplicate-ignore-db=testlog_slave_updatesskip-slave-start#---INNODB---#default-storage-engine=INNODBinnodb_data_home_dir=E:\MySQL\mysql-5.6.17-winx64\datainnodb_data_file_path=ibdata1:12M:autoextendinnodb_autoextend_increment=500innodb_log_group_home_dir=E:\MySQL\mysql-5.6.17-winx64\datainnodb_autoextend_increment=500innodb_log_group_home_dir=E:\MySQL\mysql-5.6.17-winx64\datainnodb_buffer_pool_size=20Minnodb_additional_mem_pool_size=10Minnodb_log_files_in_group=3innodb_log_file_size=512Minnodb_log_buffer_size=8Minnodb_flush_log_at_trx_commit=1innodb_lock_wait_timeout=120innodb_max_dirty_pages_pct=75innodb_io_capacity=100innodb_thread_concurrency=32innodb_open_files=1024innodb_file_per_table=1[mysqldump]quickmax_allowed_packet=16M[mysql]auto-rehash#RemovethenextcommentcharacterifyouarenotfamiliarwithSQL#safe-updates#prompt=(\u:\R:\m:\s)[\d]default-character-set=utf8[myisamchk]key_buffer_size=128Msort_buffer_size=128Mread_buffer=2Mwrite_buffer=2M[mysqlhotcopy]interactive-timeout2、添加环境变量：3、cmd命令下操作：注册windows系统服务将mysql注册为windows系统服务、启动服务mysql、修改root账号的密码