Mysql解压版安装重要信息(共4页)

精选优质文档-倾情为你奉上Mysql解压版安装重要信息1、my.ini配置信息clientport = 3358socket = E:MySQLmysql-5.6.17-winx64mysql.sockmysqldport = 3358socket = E:MySQLmysql-5.6.17-winx64mysql.sockbasedir = E:MySQLmysql-5.6.17-winx64datadir = E:MySQLmysql-5.6.17-winx64data#- 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 = wait_timeout = skip-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:MySQLmysql-5.6.17-winx64datainnodb_data_file_path = ibdata1:12M:autoextendinnodb_autoextend_increment = 500innodb_log_group_home_dir = E:MySQLmysql-5.6.17-winx64datainnodb_autoextend_increment = 500innodb_log_group_home_dir = E:MySQLmysql-5.6.17-winx64datainnodb_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 = 1mysqldumpquickmax_allowed_packet = 16Mmysqlauto-rehash# Remove the next comment character if you are not familiar with SQL#safe-updates#prompt=(u:R:m:s)ddefault-character-set=utf8myisamchkkey_buffer_size = 128Msort_buffer_size = 128Mread_buffer = 2Mwrite_buffer = 2Mmysqlhotcopyinteractive-timeout2、添加环境变量：3、cmd 命令下操作：注册windows系统服务将mysql注册为windows系统服务、启动服务mysql、修改 root 账号的密码专心-专注-专业