WampServer

I did a mistake I think.

I was in phpMyAdmin and I found a setting to put a password.
i did it.

I inserted a Password, and it gave me also some code. I think it was the hash but I'm not sure.


Anyhow from that moment on, each time I try to connect MySQL via myphpadmin I get this message:

Error
MySQL said:

#1045 - Access denied for user 'root'@'localhost' (using password: NO)
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.


No way to be able to connect MySQL via comand line neither.

What can I do please?



Edited 1 time(s). Last edit at 10/27/2012 09:48PM by Tiziano.

You now need to tell phpMyAdmin that you have a password set on the 'root' userid.

Edit this file
D:\wamp\apps\phpmyadmin3.5.1\config.inc.php ( version may be different )

Change yours to this below and phpMyAdmin will ask you for a Userid and Password when you run it.

Use 'root' and the new password you set earlier.


$cfg['Servers'][$i]['verbose'] = 'localhost';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'http';
$cfg['Servers'][$i]['user'] = '';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['AllowNoPassword'] = false;
$cfg['Servers'][$i]['LogoutURL'] = 'http://localhost/';

Done

it asks me login and password.
I write the login and the passowrd giving the OK but it doesn't let me in

Are you sure you are using the correct userid and password

yes

I was logedin as root
I tried to give the password "tasto" when I did the disaster.

Then that is not the password you created.


If you have not done anything other than play with wamp I would UNINSTALL it ( make sure you delete the c:\wamp folder after the un-install) and then re-install.

This will get your mysql databases back to their initial state and you can start again and make sure you remember the password you set this time.

Actually before you re-install. Try F5 on your browser to force a refresh.

I di it now

It was the only one way to be operative

I just deleted everything except c:\wamp\www because I have something on this dir.
The rest totally deleted and reinstalled WAMP.

Now I reinstall the CURL dll and it will be ok

I'm wonder if there is a method to avoid the reinstallation

Thank you very much



Edited 1 time(s). Last edit at 10/28/2012 12:40PM by Tiziano.

Yes but you have to know what you are doing.
I am afraid I was assuming you were a beginner and the uninstall and reinstall is the simplest thing for a beginner to do to recover from this situation.



Try reading this before you go adding a password again.

[forum.wampserver.com]

Right

i'm beginner with it

I think I did something worng misunderstanding the instrucions