How to install Mysql5.7.11 in 64-bit Win10 System (case study), win10mysql5.7.11

How to install Mysql5.7.11 in 64-bit Win10 System (case study), win10mysql5.7.11

Recently installed in the 64-bit Win10 system mac book notebook with mysql-installer-community-5.7.11.0 to install Mysql5.7.11, always stuck When configuring mysql server, error. (It's okay to install it automatically on the same windows system as other PCs.) You have to install it manually, but there are still many problems. The successful installation case is as follows:

I. Prepare to install software

1.mysql.comdownload mysql-5.7.11-win32.zip

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

3. vcredist_x64 (install MicroSoft Visual C ++ 2nd Redistributable Package in step 1)

Ii. Install Mysql

1.decompress mysql-5.7.11-win32.zip to c: \ mysql-5.7.11-win32

2. Set the environment variable MYSQL_HOME = c: \ mysql-5.7.11-win32, path = % MYSQL_HOME % \ bin

3. The key step is to set my. ini.

[WinMySQLAdmin] Server="C:/mysql-5.7.11-win32/bin/mysqld.exe" [client] no-beep # pipe # socket=mysql port=3306 [mysql] default-character-set=utf8 # For advice on how to change settings please see # http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html # *** DO NOT EDIT THIS FILE. It's a template which will be copied to the # *** default location during install, and will be replaced if you # *** upgrade 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 data # cache in MySQL. Start at 70% of total 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_TRANS_TABLES sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" character-set-server=utf8 innodb_flush_method=normal

4. Enter cmd as an administrator (the following are all)

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

6. mysqld -- initialize: generate the data directory and initialize the data.

7. In the mysql_error_log file in the data directory, find [Note] A temporary password is generated for root @ localhost: 5ZC = 7Qe & eneg. The three marked in red after ":" is the initial password.

8. start the service. net start mysql or start it in the service.

9. mysqld

10. Run cmd and mysql-uroot-p.

Enter the initial password to connect to the mysql database and change the password as follows:

set password=password('123456');flush privileges;

Log out and log on again. Just use the new password:

mysql -uroot -p123456

3. To facilitate the installation of workbench

1. Install Visual C ++ 2013 Redistributable Package first

2. Install workbench 32-bit

There are no difficulties in these two steps.

The above section describes how to install Mysql5.7.11 on a 64-bit Win10 system. I hope it will help you. If you have any questions, please leave a message and I will reply to you in time. Thank you very much for your support for the help House website!