03 - How to change the Root password in MySQL using PhpMyAdmin

http://danscourses.com - A brief tutorial on installing and running Wampserver and changing the root mysql pass word using phpmyadmin
http://www.danscourses.com/CMS-Joomla/install-wampserver-452.html

Category:

Education

Tags:

• mysql
• wampserver
• phpmyadmin
• wamp
• webserver

[edryl12345]

i did everything in the video but when i open config.inc.php,there is no "mypass" in the password..i am using windows vista in my operating system..please help

[danscourses]

@edryl12345 mypass is the password I changed my password to. You are looking form the password line and it will have "" as the password which is nothing you will need to fill in your password between the quotation marks

[Badal2850]

I did everything as described in the video...Now I am LOCKED OUT!

[danscourses]

@Badal2850 maybe you pressed the wrong "Go" button in phpmyadmin and the password was never actually changed... then if you went and changed the password in the config file you would get locked out. Try changing the password in the config file back to nothing and see if you can get in...

[danscourses]

@Badal2850 Okay I am almost positive that if you change the config.inc.php password line back to ''; that you will be able to get back in with phpmyadmin. The problem is probably that you actually never changed the mysql password. I have done the same thing with the go buttons on the right hand side in phpmyadmin you have to hit the specific go button for that area that you are changing... give it a try and see if I am right

[danscourses]

@Badal2850 did you get it fixed?

[Aizaz07Az]

thank u So much! This was seriously pissing me off!

[Casualprograms]

I like apples too!

[PuhjaHollywood]

Worked for me, thanks!

[CrownJulesB]

Thanks dan. I almost locked myself out of my server messing with the paswords! Won't be doing that again.

[NextCosmin]

Can you tell me please how to add to phpMyAdmin an existing database? like editing the password for that existing database

[crazlynn1]

I find it so funny in the end how he goes "the other thing...oh anyway hope that was helpful...i jus gonnna...anyway" lol....worked for me....thanks a mil!

[NonOffcial]

Tnx really that did help me:) ty

[FOXSniping]

THANKS THIS REALLY HELPED THUMBS UP :)