Win7 Install MySQL error: "MySQL service failed to start" 3534 issues

Win7 install MySQL, only to "net start MySQL" This step error: 3534 errors:

It is a compressed file downloaded directly from the official website. Not a setup file.

Workaround:

1: Environment variable Path added complete (example: H:\mysql\\bin

2: In the MySQL directory, create a new data directory.

3: Create a new default profile My.ini in the MySQL directory.

Content:

[MySQL]
# Set the MySQL client default character set
Default-character-set=utf8
[Mysqld]
#设置3306端口
Port = 3306
# set up the MySQL installation directory
Basedir=h:\mysql
# Set up a storage directory for MySQL database data
Datadir=h:\mysql\data
# Maximum number of connections allowed
max_connections=200
# The character set used by the service side defaults to the 8-bit encoded latin1 character set
Character-set-server=utf8
# The default storage engine that will be used when creating a new table
Default-storage-engine=innodb

4: Uninstall, reload, initialize MySQL, and finally start the MySQL service.

Open cmd as Administrator

1 C:windows\system32>mysqld--romve  

4 c:windows\system32>net start MySQL

The first step of initialization is important if error occurs you delete the new Data folder in 2

Mysql-u root-p

Login without password for the first time, press ENTER directly if an error occurs:

Open My.ini Find [mysqld] and add the following

This sentence: Skip_grant_tables (meaning to start the MySQL service to skip permission table authentication)

A: And then you start the database to change the password.

Start-up, cmd-to-net start MySQL (start MySQL service)---> mysql enter (MySQL prompt will appear if successful)

B. Enter use MySQL; (Connection rights database).

C. Password change: Update user set Authentication_string=password (' 123 ') where user= ' root ';

D. Refresh permissions (required steps): flush privileges;. Refresh will not take effect

E. Quit quit.

F. Remove the skip_grant_tables from the My.ini in the 3rd step (do not let him skip the authorization form when starting the MySQL service)

G. Restart MySQL, then enter, use the username root and the new password just set 123 can log in.

When executing MySQL statements if you must reset your password using ALTER USER statement before executing ....

Step 1:set PASSWORD = PASSWORD (' Your new PASSWORD ');

Step 2:alter USER ' root ' @ ' localhost ' PASSWORD EXPIRE never;

Step 3:flush privileges;

Complete the above three steps to exit the re-login, using the new settings of the password on the line, other as-is input can

Win7 Install MySQL error: "MySQL service failed to start" 3534 issues