# for advice The change settings see# http://dev.mysql.com/doc/refman/5.6/en/ server-configuration-defaults.html# * * * does not EDIT the this FILE. It's a template which'll be copied to the# * * * default location during install, and would be replaced if you# * * * Upgrade To a newer version of MySQL. [mysqld] Character_set_server = utf8# Remove Leading # and set to the amount of RAM for the most important data# cache in Mysql. Start at 70% of all RAM for dedicated server, else 10%.# innodb_buffer_pool_size = 128m# Remove Leading # to turn on a V ery important data Integrity option:logging# changes to the binary log between backups.# log_bin# These is commonly set, Remove the # and set as required. Basedir = C:\Program files\mysql-5.6.24-winx64 (self-configuring) DataDir = C:\Program Files\mysql-5.6.24-winx64\data (self-configuring) port = 3306# server_id = ... # Remove leading # To set options mainly useful for reporting servers.# the server defaults is FA Ster for transactions and fast selects.# AdJust sizes as needed, experiment to find the optimal values.# join_buffer_size = 128m# sort_buffer_size = 2m# read_rnd_buf Fer_size = 2M Sql_mode=no_engine_substitution,strict_trans_tables [client]port = 3306default-character-set = UTF8
1. The above is to modify the My.ini configuration, you can directly copy the folder My-dafult.ini to modify, remember to modify Basedir and DataDir
2. Go to the MySQL folder bin and execute the command prompt
3.mysqld-install to install MySQL
4.net start MySQL start MySQL service
5.mysql-u root-p Login
Since MySQL 5.7 does not have a data file, it needs to be built by itself. There is the path configuration, directly configured to the bin just fine
Mysql 5.6 Decompression Version Configuration scheme