MYSQL installation Configuration

As a back-end developer, I didn't know much about MySQL, and I was pretty speechless about myself, so take advantage of spare time to do some research.

Everything starts hard ... Then the process is difficult ... The final end is difficult ...

Joking, just in the QQ technology Group heard such a word

OK, let's get to the next step.

First step: Download MySQL (my system is win7 64bit, so I chose the 5.6.32-free version)

Download Home: http://dev.mysql.com/downloads/mysql/5.6.html

MySQL installation files are divided into two types, one in MSI format and one in ZIP format. If the MSI format can be directly clicked on the installation, according to the installation prompts it to install (I believe you can read English tips), General MySQL will be installed in C:\Program files\mysql\mysql Server 5.6 Directory The ZIP format is self-extracting, and after decompression, MySQL can actually be used, but to configure.

After decompression can rename the folder, put in the appropriate location, personal suggestions to rename the folder to MySQL Server 5.6, put on the E disk. Of course you can put it anywhere you want.

Do not rush to use at this time, will error, as follows

This is because we have not yet configured environment variables

Configuring environment variables is simple:

My Computer, properties, advanced environment variables

Select Path, after which you add: the path to your MySQL bin folder (e.g. E:\MySQL Server 5.6\bin)

Path= ...; E:\MySQL Server 5.6\bin (note is append, not overwrite)

After configuring the environment variables do not be busy to start MySQL, we also need to modify the configuration file, mysql-5.6.1x default configuration file is C:\Program files\mysql\mysql Server 5.6\ My-default.ini, or build yourself a My.ini file,

In which the configuration () is modified or added:

[Mysqld]

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)

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

Input: cd E:\MySQL Server 5.6\bin into the bin folder of MySQL (regardless of whether the environment variable has been configured, but also to enter the Bin folder, or after the service will still error)

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

Success will show: Service successfully installed.

Installation Successful

Precautions:

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

The above is the entire content of this article, about MySQL 5.6 for Windows decompression version of the configuration installation of the introduction, I hope that everyone's learning is helpful.

MYSQL installation Configuration