A quick fix for Mysql installation failure _mysql

The most troublesome problems and solutions that occur during the installation of MySQL

After installation, startup is not successful, on the card, the program is not responding.

How to resolve:

Find the MySQL installation directory

#Path to the database root
datadir= "C:/programdata/mysql/mysql Server 5.5/data/"

This directory is used to store the database and tables we create in the future, you only need to

C:/programdata/mysql/mysql Server 5.5 can be removed and reinstalled.

Below is a look at a case of MySQL installation failure under Windows

Operating system: windows8.1, previously installed MySQL, this installation in the last configuration of the implementation of the "Apply security Settings" in the process of pop-up classic error:

Access denied for user ' root ' @ ' localhost ' (using Password:yes)

Online search for a variety of methods, there are: the original MySQL did not uninstall complete, failure, there are changes to the password, the solution is as follows:

The workaround is to reset the root password by following the steps in the Windows platform:

1, as a system administrator login to the system;

2, if the MySQL server is running, stop it.

If it is a server running as a Windows service, go to Service Manager: Start menu-> Control Panel-> management tools-> Services

If the server is not running as a service, you may need to use Task Manager to force it to stop.

3. Create 1 text files and place the following commands on a single line:

SET PASSWORD for ' root ' @ ' localhost ' = PASSWORD (' Mynewpassword ');

Save the file with any name. In this case, the file is F:\mysql-init.txt.

4, enter the DOS command prompt: Start menu-> run-> cmd

Assume that you have installed MySQL to F:\Program Files\mysql. If you have MySQL installed in another location, please adjust the following command accordingly.

At the DOS command prompt, go to the MySQL folder and execute the command:

F:

CD F:\Program files\mysql\mysql server 5.1\bin
F:\Program files\mysql\mysql Server 5.1\bin>mysqld-nt-- Init-file=f:\mysql-init.txt

When the server starts, executes the contents of the file named by the "--init-file" option, which reads the SQL command from the specified file at startup, and changes the root user password. After the server has successfully started, you should delete the C:mysql-init.txt.

5, restart the MySQL service.

The above is a small set to introduce the MySQL installation failure of the quick solution, I hope to help you, if you have any questions please give me a message, small series will promptly reply to everyone. Here also thank you very much for the cloud Habitat Community website support!