Configuration deployment for mysql5.7.7 in Win7

1. Download mysql-5.7.7-rc-winx64.zip from MySQL website;

2. Extract the Mysql-5.7.7-rc-winx64.zip to the appropriate installation directory (for example: D:\dev_tools directory);

3. Name the My-default.ini file added by the D:\dev_tools\mysql-5.7.7 file as My.ini;

4. Modify the My.ini file (not modified can also):

# for advice The change settings # http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html # * * * Don't EDIT 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. [Client] Default-character-set=utf8 [Mysqld] # 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 very 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 = "D:\dev_tools\mysql-5.7.7" DataDir = "D:\dev_tools\mysql-5.7.7\data" Tmpdir = "D:\dev_tools\mysql-5.7.7\data" Socket = "D:\dev_tools\mysql-5.7.7\data\mysql.sock" Port = 3306 Log-error = "D:\dev_tools\mysql-5.7.7\data\mysql_error.log" # server_id = ... max_connections = 100 Table_open_cache = 256 Query_cache_size = 1M Tmp_table_size = 32M Thread_cache_size = 8 Innodb_data_home_dir = "D:\dev_tools\mysql-5.7.7\data\" Innodb_flush_log_at_trx_commit = 1 Innodb_log_buffer_size = 128M Innodb_buffer_pool_size = 128M Innodb_log_file_size = 10M Innodb_thread_concurrency = 16 innodb-autoextend-increment = 1000 # Remove Leading # To set options mainly useful for reporting servers. # The server defaults is faster for transactions and fast selects. # Adjust sizes as needed, experiment to find the optimal values. Join_buffer_size = 128M Sort_buffer_size = 32M Read_rnd_buffer_size = 32M Max_allowed_packet = 32M Explicit_defaults_for_timestamp = True Sql_mode= "Strict_trans_tables,no_auto_create_user,no_engine_substitution"

5. Configure the environment variables to add "D:\dev_tools\mysql-5.7.7\bin" to Path (note the ";" between the variables) separated);

6. Add Service: Open cmd command mode, switch to directory "D:\dev_tools\mysql-5.7.7\bin", execute Mysqld-install mysql57 (can be equipped, default is MySQL);

7. Start the service: in cmd command mode, enter net start mysql57, the database can be started.

8. Change the root password:

Command line execution: Mysql–u root-p Mysql>show databases; Mysql>use MySQL; mysql> SET Password=password (' 123456 '); mysql> FLUSH privileges; Mysql> QUIT

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Configuration deployment for mysql5.7.7 in Win7