MySQL 5.6 for WINDOWS32 version Configuration installation

Today when configuring MySQL server:error: Can ' t connect to mysql server on ' localhost ' (10061), finding a lot of methods on the Internet doesn't work. Finally, I chose to reconfigure and use the simplest configuration , only to let MySQL run, the reason for the final success I think it should be the MySQL configuration causes the service to start the problem.

A. Software version:

Mysql-5.6.24-win32.zip-Free installation (both 64-bit and 32-bit can be used)

　　two. Configuration steps:

　　1. After the decompression can rename the folder, put in the appropriate location, personal suggestions to rename the folder to MySQL Server 5.6, put in the C:\Program files\mysql path. Of course you can put it anywhere you want.

2. Configure environment variables:

(1) My Computer, properties, advanced environment variables

(2) Select path and add the following: The path to your MySQL bin folder (e.g. C:\Program files\mysql\mysql Server 5.6\bin)

(3) Path= ...; C:\Program files\mysql\mysql Server 5.6\bin (Note: Append before the end of the first number)

3. Modify the configuration file:

MYSQL-5.6.1X The default configuration file is in C:\Program files\mysql\mysql Server 5.6\my-default.ini, or create a My.ini file yourself,

In which the configuration () is modified or added:

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

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

4. Install MySQL:

(1) Run cmd as administrator (be sure to run as administrator, or not have enough permissions),

(2) Input: cd C:\Program files\mysql\mysql Server 5.6\bin into the MySQL Bin folder

(3) Enter Mysqld-install (if run without administrator, there will be an error due to insufficient permissions: Install/remove of the Service denied!)

Installation Successful

5. Start the service:

Input net start MySQL

6. Login:

Enter Mysql-u root-p (first login without password, press ENTER directly), Login success!

　　three . Precautions :

The My.ini file must be encoded in English (such as ANSI in Windows), not UTF-8 or GBK, and so on.

　　

　　

MySQL 5.6 for WINDOWS32 version Configuration installation