The dreaded error "1045 - Access denied for user 'root'@'localhost' (using password: NO)" has been baffling php developers - do a google search on it and you shall see. I spent good 3 hours on it.
I faced this error all because I decided to change the MySQL blank password to a non-blank password. And after that I tried everything I could - changing PHPMyAdmin config files config.inc.php config.default.php, reinstalling the WAMP package (I used EasyPHP), rebooting. I won't go into the details of what I tried.
And then I found a workaround - under PHPMyAdmin folder locate /scripts/signon.php and run it in the browser. You will be asked for the login details as below.
And then another login screen pops-up, enter the mysql details:
Finally, the screen that I wanted to see:
I wonder the number of years PHPMyAdmin is in development and yet we see these errors? I think PHPMyAdmin is just overrated. I just wanted some GUI to manage MySQL. For some serious development I think it's better to use window based MySQL's new Workbench software instead of the crappy web based PHPMyAdmin.
Tech Innovations That Will Make You Want To Live In Your Car
23 minutes ago