views:

39

answers:

2

I changed the password for MySQL root and now I can't login to phpmyadmin. I've rebooted, followed the directions here http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html and it still won't let me login.

What else can I do to fix this? Thanks!

+2  A: 

Sounds more like a phpMyAdmin configuration problem.

Look in your config.inc.php and find these lines:

/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = ''; // you might need to change this
$cfg['Servers'][$i]['extension'] = 'mysql';
Matt
A: 

If you are using Windows, go to your wamp directory on the drive on which you have installed then go into apps and then go to phpmyadmin application folder. Look for a file named config.inc.php. Open it with notepad and look for this line :-

$cfg['Servers'][$i]['password'] = ''

and set the password here in between quotes.

Restart your wamp server and i think it should be done!

EDIT :- You may also need to change the username

Ankit Rathod