64-bit WIN10 system installation Mysql5.7.11 method (case detailed) _mysql

Recently installed on the Mac book notebook with a 64-bit WIN10 system with mysql-installer-community-5.7.11.0 to install Mysql5.7.11, when the MySQL server is configured always stuck, error. (In other PCs the same Windows system, automatic installation is no problem), decided to manually install, still a lot of problems, the final successful installation cases are as follows:

I. Preparing to install the software

1.mysql.com Download Mysql-5.7.11-win32.zip

2.mysql-workbench-community-6.3.6-win32.msi

3.vcredist_x64 (step 2nd requires installation of Microsoft Visual C + + 2013 redistributable Package)

Two. Install MySQL

1. Extract Mysql-5.7.11-win32.zip to C:\mysql-5.7.11-win32

2. Set environment variable Mysql_home=c:\mysql-5.7.11-win32, Path=%mysql_home%\bin

3. The key step is the setting of My.ini, and mine is

[Winmysqladmin] Server= "C:/mysql-5.7.11-win32/bin/mysqld.exe" [client] No-beep # pipe # socket=mysql port=3306 [MySQL] Default-char Acter-set=utf8 # for advice on ' How to ' change settings, please, please. # Http://dev.mysql.com/doc/refman/5.6/en/server-configu ration-defaults.html # * * * does not EDIT this FILE. It's a template which'll be copied to the # * * * * * * * * * * * * * * * * * * location during install, and'll be replaced 
Rade to a newer version of MySQL. [mysqld] Explicit_defaults_for_timestamp = TRUE # Remove Leading # and set to the amount of RAM for the most important D ATA # Cache in MySQL. 
Start at 70% all RAM for dedicated server, else 10%. Innodb_buffer_pool_size = 2G # Remove Leading # to turn on a very important data integrity Option:logging # changes to 
The binary log between backups. 
# Log_bin # These are commonly set, remove the # and set as required. Basedir= "C:\mysql-5.7.11-win32\" datadir= "C:\mysql-5.7.11-win32\data\" port=3306 server_id=1 geNeral-log=0 general_log_file= "Mysql_general.log" slow-query-log=1 slow_query_log_file= "Mysql_slow_query.log" Long_ query_time=10 log-error= "Mysql_error_log.err" Default-storage-engine=innodb max_connections=1024 query_cache_size= 128M key_buffer_size=128m innodb_flush_log_at_trx_commit=1 innodb_thread_concurrency=128 innodb_autoextend_ 
increment=128m tmp_table_size=128m # Remove Leading # To set options mainly useful for reporting servers. 
# The server defaults are faster 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_buffer_size = 2M #sql_mode =no_engine_substitution,strict_t 
Rans_tables sql-mode= "Strict_trans_tables,no_auto_create_user,no_engine_substitution" Character-set-server=utf8 Innodb_flush_method=normal

4. Administrator identity into cmd (below)

5.mysqld--install mysql--defaults-file=c:\mysql-5.7.11-win32\my.ini install MySQL service

6.mysqld--initialize This is to generate the data directory and initialize it

7. In the Data directory Mysql_error_log file, find [note] A temporary password be generated for Root@localhost:5zc=7qe&eneg, ":" The three digits on the back of the red logo are the initial password

8. Start the service net start MySQL or start in the service

9.mysqld

10. New Open cmd, mysql-uroot-p

Enter the initial password connection after entering the MySQL database, modify the password as follows:

Set Password=password (' 123456 ');
Flush privileges;

Sign out again and use the new password:

mysql-uroot-p123456

Third, to facilitate the operation of the installation of Workbench

1. Install Visual c++2013 Redistributable Package first

2. Install Workbench 32-bit

There is no difficulty in these two steps.

The above is a small series to introduce the 64-bit WIN10 system installation Mysql5.7.11 method, I hope to help you, if you have any questions please give me a message, small series will promptly reply to everyone. Here also thank you very much for the cloud Habitat Community website support!