1 # Example MySQL config file for small systems. 2 # 3 # This is for a system with little memory (<= 64M) where MySQL is only used 4 # from time to time and it‘s important that the mysqld daemon 5 # doesn‘t use much resources. 6 # 7 # MySQL programs look for option files in a set of 8 # locations which depend on the deployment platform. 9 # You can copy this option file to one of those10 # locations. For information about these locations, see:11 # http://dev.mysql.com/doc/mysql/en/option-files.html12 #13 # In this file, you can use all long options that a program supports.14 # If you want to know which options a program supports, run the program15 # with the "--help" option.16 17 # The following options will be passed to all MySQL clients18 [client]19 #password    = your_password20 port        = 330621 socket        = /tmp/mysql.sock22 default-character-set = utf823 24 # Here follows entries for some specific programs25 26 # The MySQL server27 [mysqld]28 port        = 330629 socket        = /tmp/mysql.sock30 skip-external-locking31 key_buffer_size = 16K32 max_allowed_packet = 1M33 table_open_cache = 434 sort_buffer_size = 64K35 read_buffer_size = 256K36 read_rnd_buffer_size = 256K37 net_buffer_length = 2K38 thread_stack = 128K39 basedir = "E:\\MySQL"40 datadir = "E:\\MySQL\\data"41 character-set-server = utf842 43 # Don‘t listen on a TCP/IP port at all. This can be a security enhancement,44 # if all processes that need to connect to mysqld run on the same host.45 # All interaction with mysqld must be made via Unix sockets or named pipes.46 # Note that using this option without enabling named pipes on Windows47 # (using the "enable-named-pipe" option) will render mysqld useless!48 # 49 #skip-networking50 server-id    = 151 52 # Uncomment the following if you want to log updates53 #log-bin=mysql-bin54 55 # binary logging format - mixed recommended56 #binlog_format=mixed57 58 # Causes updates to non-transactional engines using statement format to be59 # written directly to binary log. Before using this option make sure that60 # there are no dependencies between transactional and non-transactional61 # tables such as in the statement INSERT INTO t_myisam SELECT * FROM62 # t_innodb; otherwise, slaves may diverge from the master.63 #binlog_direct_non_transactional_updates=TRUE64 65 # Uncomment the following if you are using InnoDB tables66 #innodb_data_home_dir = C:\\mysql\\data\67 #innodb_data_file_path = ibdata1:10M:autoextend68 #innodb_log_group_home_dir = C:\\mysql\\data\69 # You can set .._buffer_pool_size up to 50 - 80 %70 # of RAM but beware of setting memory usage too high71 #innodb_buffer_pool_size = 16M72 #innodb_additional_mem_pool_size = 2M73 # Set .._log_file_size to 25 % of buffer pool size74 #innodb_log_file_size = 5M75 #innodb_log_buffer_size = 8M76 #innodb_flush_log_at_trx_commit = 177 #innodb_lock_wait_timeout = 5078 79 [mysqldump]80 quick81 max_allowed_packet = 16M82 83 [mysql]84 no-auto-rehash85 # Remove the next comment character if you are not familiar with SQL86 #safe-updates87 88 [myisamchk]89 key_buffer_size = 8M90 sort_buffer_size = 8M91 92 [mysqlhotcopy]93 interactive-timeout

 1 # For advice on how to change settings please see 2 # http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html 3 # *** DO NOT EDIT THIS FILE. It‘s a template which will be copied to the 4 # *** default location during install, and will be replaced if you 5 # *** upgrade to a newer version of MySQL. 6  7 [mysqld] 8  9 # Remove leading # and set to the amount of RAM for the most important data10 # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.11 # innodb_buffer_pool_size = 128M12 13 # Remove leading # to turn on a very important data integrity option: logging14 # changes to the binary log between backups.15 # log_bin16 17 # These are commonly set, remove the # and set as required.18 # basedir = .....19 # datadir = .....20 # port = .....21 # server_id = .....22 basedir = D:/MySQL-5.6.20-X6423 datadir = D:/MySQL-5.6.20-X64/data24 port = 330625 #server_id = .....26 27 character-set-server = utf828 default-storage-engine = INNODB29 30 # Remove leading # to set options mainly useful for reporting servers.31 # The server defaults are faster for transactions and fast SELECTs.32 # Adjust sizes as needed, experiment to find the optimal values.33 # join_buffer_size = 128M34 # sort_buffer_size = 2M35 # read_rnd_buffer_size = 2M 36 37 sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 38 39 [client]40 default-character-set=utf8