WampServer

i cant find out how to change the password for mysql. i know it is installed but i cant find out where i go to change the password. i just started using mysql and i dont know this program all that well thanks in advance

Click on your wamp server. Then a menu should open. Under the services portion go to MySQL then click on MySQL consule. A window should open. When it asks for a password just hit enter then you type the following

SET PASSWORD FOR 'root'@'%' = PASSWORD('newpassword');

After this you need to change you config file for phpmyadmin. You can do this by going to my computer, then click on your c drive(or what ever drive you have) then find wamp.
Under wamp go to your www file. Then click on phpmyadmin. In phpmyadmin you want to find you config.inc file. Click on it. On line 75 add a password. This must be the same password that you entered for MySQL. It should look like this.

Before change:
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = ''; //This is were you want to put your password
$cfg['Servers'][$i]['only_db'] = ''; // between the ' '


After change:
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'newpassword';
$cfg['Servers'][$i]['only_db'] = '';

Now restart you server.

Also, for more information on MySQL go to

[dev.mysql.com]

thank you very much

i got the password changed and now i tried to finish up my installation of my forum and i get this

phpBB : Critical Error

Could not connect to the database

so now im really lost.

i tried this
SET PASSWORD FOR 'root'@'%' = PASSWORD('newpassword');

and then i get this

#1045 - Access denied for user 'NICO'@'localhost' (using password: YES)
i uninstalled and tried all over again and when i put in the

SET PASSWORD FOR 'root'@'%' = PASSWORD('newpassword');

i got a error 1133



Post Edited (06-06-06 07:16)

make sure you restart apache and mysql after youc change the password for the new settings to take effect.

i did that and i still get the error. so i made a new user with full privlages and i still need to give root a password and i cant find the right way to do it

ok i changed the root password. on the mysql and also phpmyadmin and that works good now. but when you log into my IP you go to the phpmyadim page how can i stop that?

I don't know about anyone else however I have been trying to fix error #1045 for a day now. I have read so many different ways to deal with this issue, none of them worked. I was pulling my hair out and starting to convince myself I was a first class idiot. However, I finally came upon this thread and tomfmason's reply and now, after all this time, I can finally get to localhost without that damn #1045 error stating access denied for user root@localhost blah blah blah.

THANK YOU TOMFMASON for finally stating exactly what needs to be done in an intelligable way that anyone can follow and that DOES work!

Jennifer C. Swartz



Jeniveve