Operating system: Windows 2003
MySQL version: Mysql-5.6.22-winx64.zip
Installation and configuration steps:
1, unzip MySQL;
2. Create the My.ini file and write the contents:
[client]no-beepport=3369default-character-set=utf8[mysql]default-character-set=utf8[mysqld]port=3369# MySQL Extract directory basedir=d:/mysql_test/mysql-5.6.22-winx64#mysql data file location datadir=d:/mysql_test/mysql-5.6.22-winx64/ Datacharacter-set-server=utf8default-storage-engine=innodbsql-mode= "Strict_trans_tables,no_auto_create_user,no _engine_substitution "# General and Slow logging.log-output=filegeneral-log=0general_log_file=" Win-san3cogq5se.log " slow-query-log=1# Slow query log file storage location slow_query_log_file= "D:/mysql_test/mysql-5.6.22-winx64/slow_sql_log.log" long_query _time=5log-error= "Win-san3cogq5se.err" server-id=1max_connections=151query_cache_size=512mtable_open_cache= 2000tmp_table_size=706mthread_cache_size=16#*** MyISAM Specific Optionsmyisam_max_sort_file_size=10gmyisam_sort_ buffer_size=2gkey_buffer_size=8mread_buffer_size=64kread_rnd_buffer_size=256ksort_buffer_size=32m#*** INNODB Specific Options ***innodb_additional_mem_pool_size=32minnodb_flush_log_at_trx_commit=0innodb_log_buffer_size= 16minnodb_buffer_pool_Size=4ginnodb_log_file_size=1024minnodb_thread_concurrency=33innodb_autoextend_increment=64innodb_buffer_pool_ Instances=16innodb_concurrency_tickets=5000innodb_old_blocks_time=1000innodb_open_files=300innodb_stats_on_ Metadata=0innodb_file_per_table=1innodb_checksum_algorithm=0back_log=80flush_time=0join_buffer_size=32mmax_ Allowed_packet=24mmax_connect_errors=100open_files_limit=4161query_cache_type=1sort_buffer_size=32mtable_ Definition_cache=1400binlog_row_event_max_size=8ksync_master_info=10000sync_relay_log=10000sync_relay_log_info =10000
3. Create MySQL Startup service
Mysqld.exe-install mysql< Service Name >--defaults-file= "My.ini file path", Mysql/bin, cmd
Go to Windows Management-services to see if the MySQL service was created successfully and started the service;
Delete the MySQL service;
Mysqld.exe-remove mysql< Service Name >
4, test the MySQL installation is successful; Host:localhost user:root password: (empty, first install no password)
5, set the user
#删除匿名用户
#创建新用户并限制可访问ip, such as:
User name Newuser,host is 10.64.7.%, meaning, only from 10.64.7.% this address segment to access;
#使root用户仅能在本机使用, Host is localhost,127.0.0.1,::1 (this is IPv6 's 127.0.0.1) and set the password;
6, permission authorization, the principle is the minimum permission authorization.
MySQL Uncompressed edition installation notes (Windows)