Windows7 Install Mysql 5.6 uncompressed version _mysql

Tools/raw Materials

Win7 Operating system

Mysqlzip Format installation Package

Method/Step

The MySQL installation file is 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 gave to install (I believe everyone can read English in English prompts), the general MySQL will be installed in the C:\Program files\mysql\mysql Server 5.6 in this directory Zip format is to extract, after decompression in fact, MySQL can be used, but to configure.

After decompression can be renamed the folder, put to the appropriate location, personal suggestions to rename the folder to MySQL Server 5.6, placed in the C:\Program files\mysql path. Of course, you can also put yourself in any position you want to put.

After completing the above steps, many users begin to use MySQL, but there will be a graphical error. This is because the environment variables are not configured. Configuring environment variables is simple:

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

Select Path, after which you add: your MySQL Bin folder paths (such as: C:\Program files\mysql\mysql Server 5.6\bin)

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

After you configure the environment variables, do not start MySQL, we also need to modify the configuration file (if not configured, after the start of the error will appear in the diagram! : 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 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)

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

Input: cd C:\Program files\mysql\mysql Server 5.6\bin into the MySQL Bin folder (regardless of whether the environment variable has been configured, also enter the Bin folder, otherwise the start service will still report error 2)

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

Installation Successful

After the installation of a successful start service, continue to enter in cmd: net start MySQL (figure), Service start success!

At this point many people will be wrong, please see note:

Note: Error 2 and error 1067 are often present at this time.

If the error 2 system does not find a file, check to see if the profile has been modified or if the configuration file has been modified and entered the Bin folder, you need to remove MySQL (input mysqld-remove) before reinstalling (enter Mysqld- Install);

If error 1067 occurs, the profile modification error confirms that the configuration file is correct.

After the successful start of the service, you can login, such as the figure, input Mysql-u root-p (the first login without password, directly by the return), login success!

End

Attention matters

My.ini files must be encoded in English (such as ANSI in Windows), not UTF-8 or GBK.

To modify the root password:

1, >use myql;

2, >update Mysql.user set Password=password (' root ') where user= ' root ';

3, flush privileges;

4, >exit; When you log out, you need a new password to login again.

Ram Files (x86) \common Files\Microsoft Shared\MSEnv\TextMgrP.dll