ka_lin ka_lin - 1 year ago 98
MySQL Question

PhpMyAdmin password

I get the error #1045 - Access denied for user 'root'@'localhost' (using password: NO)
after I accidentaly changed the password in phpmyadmin for root and . the problem is i cannot change common.lib.php. I want to revert these changes in mysql somehow... Doe to the security of the server i cannot change much

Answer Source

It's been a while since I've used phpMyAdmin, but if I'm not mistaken, it stores it's passwords in the mysql database it self. So, if you are able to get access to the command-line of the server, you are able to change the password using simple SQL statements.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download