Re: Please Help... Access Denied phpMyAdmin
Posted by:
unwiredmedic
(---.lightspeed.renonv.sbcglobal.net)
Date: March 08, 2011 04:28AM
So far, I hear that if you have set WAMP up and you still follow the directions implicitly and are not a novice computer user, and you try again, doing the same things prescribed over and over by "yfastud" you simply are doing them wrong every time and that you should continue, exactly as written, to do them until the result changes ( re: "the law of insanity" )
I am not saying the steps this person regurgitates in every post are wrong, but I am saying they are not working... for ME.
I am not a novice and can follow written directions well, but trying to learn to use PHP and MySQL is my goal now so I can start to build dynamic websites, and WAMP comes HIGHLY recommended by the best instructors I have ever found.
I guess I'll keep following the law of insanity (see definition below), and expect that eventually it will work. But the reality is, it's script folks. Either it works the first time, or it doesn't work at all. Resetting it and waiting 30 minutes, 3 hours, or 30 days will not change anything. After it's reset/refreshed, it either works or it doesn't, right?
There is nothing wrong with my MySQL info. It matches the steps PRECISELY. However, myPHPAdmin insists on lying to me with some confabulation about not being able to access the MySQL administration page. Some blabber about "#1045 - Access denied for user 'root'@'localhost' (using password: NO)". Come on! How can you possibly screw up no password? It doesn't ask the user anything when you open myPHPAdmin, it simply opens the error page. I even tried it in multiple browsers and after clearing the cache. Same problem. How do you configure the myPHPAdmin so you can change the user to "root" and enter the set up password to "". Oh, that's right, you follow the law of insanity. I replace the three user.xxx files in the appropriate directory. I verify the changes went through by looking at the config.inc.php file in Notepad and it is STILL showing what it is supposed to. I close WAMP and restart it. No luck. I try the same steps in the law of insanity, I restart the computer and load WAMP. No luck.
Keep doing this over and over and over and it should eventually work, even though the script never changes. Do it over and over and expect different results every time.
So I guess I'm really asking if there is really an answer to making WAMP work, or if I should try running it in a sterile virtual machine with fully verified parameters (what OS should I use, what services packs and updates should I use, which antivirus should be running, what processes should be active, what version of WAMP, what version of PHP, what version of Apache, what version of MySQL) to get it to absolutely work. Maybe my Win 7 Pro is configured wrong? Maybe I have something installed that conflicts? What do you need to make this simple tool work the way it is supposed to? Or should I abandon WAMP in favor of some other tool that is known to work? Try it once is fine, but if it doesn't work, is there really no other option?