Failing to connect to database

HOW TO RESET MySQL PASSWORD phpMyAdmin:

If the MySQL Server is running stop it!

1) Open the file my.ini - in C:\xampp\mysql\bin\my.ini

2) Under:
# The MySQL server
[mysqld]

3) add:
    skip-grant-tables

4) Start the MySQL Server and run this SQL query in phpMyAdmin.

UPDATE mysql.user SET Password=PASSWORD('Your-Password')
WHERE User='root';
FLUSH PRIVILEGES;

5) Close phpMyAdmin and Stop the MySQL Server

6) Open the file my.ini - in C:\xampp\mysql\bin\my.ini

7) Remark out the line skip-grant-tables - #skip-grant-tables

8) Re-start the MySQL Server and you should now be able to login with the new password.


For the command line version see this article:

B.5.3.2 How to Reset the Root Password

What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )