MySQL 5.6 Uncompressed Version installation configuration method graphics and text tutorial (WIN10) _mysql

I hope you like MySQL for Windows uncompressed version of the installation of this tutorial, but also hope to help you successfully install MySQL.

1, the MySQL installation file is divided into two types , one is MSI format, one is in the zip format. If the MSI format can be directly clicked on the installation, according to the installation prompts it gives installation (I believe you can read English prompts), General MySQL will be installed in the C:\Program Files (x86) \mysql\mysql Server 5.6 in this directory Zip format is to extract, after decompression in fact, MySQL can be used, but to configure.

2, after decompression can be renamed the folder, placed in the C:\Program files\mysql path

3. Configure Environment variables

My Computer-> Properties-> Advanced-> Environment variables

Select Pathto add after it: (for example: C:\Program Files (x86) \mysql\mysql Server 5.6\bin)

Path= ...; C:\Program files\mysql\mysql Server 5.6\bin (note is append, not overwritten)

As pictured, this system is WIN10

　　

4, modify the configuration file

C:\Program files (x86) \mysql\mysql Server 5.6\my-default.ini opens the file

In which you modify or add a configuration (figure):

[Mysqld]

Basedir=c:\program files\mysql\mysql Server 5.6 (directory where MySQL resides)

Datadir=c:\program files\mysql\mysql Server 5.6\data (MySQL directory \data)

The following figure:

　　

5, as an administrator to run cmd (be sure to run as an administrator, or not enough authority)

Input: CD C:\Program Files (x86) \mysql\mysql Server 5.6\bin carriage return

Then enter: Mysqld-install and then return and appear

After the installation is successful, enter net start MySQL to start the service, and then appear

　

After the service is successfully started, you can log in and enter Mysql-u root-p

The first login does not have a password, directly by the return, login success!

Wonderful topic sharing: MySQL different versions of the installation Tutorials mysql5.7 version Installation Tutorials

The above is the MySQL 5.6 installation configuration method, hope to be helpful to everybody's study.