Set the root password using phpMyAdmin

[917893678251]

This tutorial is geared towards people who use Wampserver or cannot use MySQL Administrator to set the root password.

If you're using Wampserver, make sure that the little icon is white. Not yellow or red.

In your favorite web browser, go to

You must be registered to see links

You'll be greeted with a page like this

Click on Privileges

You're greeted with a list of users that have access to your account

Check the ones in the above screenshot and press Go under
Quote

Remove selected users

Now you should be left with one user
Click on

to edit that account

Scroll down to the Change password section and enter a new password and confirm it.

Click Go

You should get a message that reads
Quote
The password for 'root'@'127.0.0.1' was changed successfully.

Now, if you click on the Privileges tab, you should be greeted with a message that reads
Quote
#1045 - Access denied for user 'root'@'localhost' (using password: NO)
That's a good sign

If you don't use phpMyAdmin, then you can continue on with your happy lives.
If you plan to use phpMyAdmin, continue reading to re-allow login

Open config.inc.php in another editor besides Notepad.

For Wampserver users, this can be found in C:\wamp\apps\phpmyadmin2.11.6
Note: Newer releases of Wampserver may use newer releases of phpMyAdmin, so your best bet would be to go to C:\wamp\apps\, then select the phpMyAdmin folder

Find

$cfg['Servers'][$i]['auth_type']     = 'config';

Change to

$cfg['Servers'][$i]['auth_type']     = 'http';

Save and close

Now, the next time you go to phpMyAdmin, you will be greeted with this to enter your username and password

Cheers

 

[Ehab]

who still uses phpmyadmin? it's very old and sterile .. and sucks
MySQL Admin FTW