WampServer

i've tryed to find someone explaining this problem and everything i found and tryed didn't stopped this error.


#1045 - Access denied for user 'root'@'localhost' (using password: NO)


If in need i can share my computer screen via skype. Please help, already stuck on it for 2 weeks

2 weeks?!

wtf ?!

get teamviewer and ill sort it out in 2 mins!

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

I get the next message, when connecting to [localhost]

MySQL retourneerde:
#1045 - Access denied for user 'root'@'localhost' (using password: YES)

phpMyAdmin probeerde met de MySQL-server te verbinden maar de server weigerde de verbinding. Controleer de machine, de gebruikersnaam en het wachtwoord in config.inc.php en zorg ervoor dat deze overeenkomen met de informatie die u van de beheerder van de MySQL-server kreeg.

I always removed wampserver and re installalled it, but again the same error.

Problem solved.

I removed all and the I installed the 32 bit version, this was is working.
And set a password for root localhost.

Then I removed all again and installed the 64 bit version. This one is now working too.

Just a question must I set a password for all the 3 root "127.0.0.1" "1" and "localhost" ?

I have set it only now for localhost

Reinstalling is not a solution

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

dbtipo,

It is best to create a different admin account completely, every hacher in the world knows about root, so its easier to try and guess the password of an account you know exists.

Create a new account, for example "admin" but thats a bit easy to guess as well!

Set it up with all the root privilages, and change the phpMyAdmin references, test it!!!

And then remove all 3 root id's.

Also it is best to create specific userids for each of your databases that only have acess to the one database, and only have simple select/insert/update/delete privilages.