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

Source: Internet
Author: User
Tags change settings dedicated server

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- 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


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 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 # # *** 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!

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.