MySQL Compression pack Edition-Configuration and installation (Windows)

1, unzip, and put the extracted folder in the appropriate location

2, configure the environment variable path, add the MySQL folder Bin directory for example: C:\Program files\mysql\mysql-5.6.25\ Bin "mysql-5.6.25" is my extracted folder, I changed my name myself.

3, modify C:\Program files\mysql\mysql-5.6.25\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-5.6.25 (MySQL directory)

Datadir=c:\program files\mysql\mysql-5.6.25\data (MySQL directory \data)

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

Input: cd C:\Program Files\mysql\mysql-5.6.25\bin into the bin folder of MySQL ( regardless of whether you have configured the environment variable, also to go to the Bin folder, or after the start of 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!)

• Installation Successful

5.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!

  Baidu Experience Address: http://jingyan.baidu.com/article/f3ad7d0ffc061a09c3345bf0.html

MySQL Compression pack Edition-Configuration and installation (Windows)