MySQL Free installation configuration

Download MySQL zip file

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

After completing the above steps, many users start using MySQL, but there is an error in the diagram. This is because environment variables are not configured.

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. C:\Program files\mysql\mysql Server 5.6\bin)

Path= ...; C:\Program files\mysql\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 (if not configured, after the start of the error will appear in the diagram Oh!). : Error 2 system cannot find file), mysql-5.6.1x default profile is 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:

[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 C:\Program files\mysql\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 start of the service will still report error 2)

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

Installation Successful

After the installation is successful, start the service, continue to enter in cmd: net start MySQL (), the service started successfully!

At this time many people will appear error, please see note:

Note: error 2 and error 1067 often occur at this time.

If the "Error 2 system cannot find a file", check whether the configuration file has been modified or whether to enter the bin directory, if the configuration file is correct and enter the Bin folder, you need to remove MySQL (input mysqld-remove) and then reinstall (Input mysqld- Install);

If error 1067 occurs, it is a configuration file modification error, verify that the configuration file is correct.

After the service started successfully, you can log in, enter Mysql-u root-p (no password for the first login, press ENTER directly), Login success!

Precautions:

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

MySQL Free installation configuration