WAMP, PHPmyAdmin issues

[modern paradox]

Alright well i have been using WAMP for a good amount of time now and just recently i decided to play around with ProjectBattle, ok so in the sql config it forced me to set a password on the phpmyadmin, so i set it as root for localhost in the Privaliges panel, ok all went well i opened the index and it worked fine, only now i cannot access my phpmyadmin panel lol, it gives me this -

Code: Select all

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.

I have tried uninstalling and deleting anything related to WAMP and MySQL and to no prevail "seems that any previous WAMP configuration is saved even after you completely uninstall it".. and there is no place i can login on the myphpadmin page.. so im very confused as to how i set a password and now im restricted access with no way to login... Can someone please help me out ?

[SpiritWebb]

You need to edit phpMyAdmin config.inc file in the c:\wamp\phpmyadmin\ and set the password for root to what you changed it too. Save it and restart WAMP. Thats what I did too get it too work.

[modern paradox]

Ok, i set the password to root "what i set in the actualy phpmyadmin page", and still no luck, restarted services, closed it out-and reopened it, no luck.

[Jackolantern]

Can you log into root through the MySQL console? That would likely be the next thing to check. That gets a few things out of the way with phpMyAdmin and can check to see if it is a password issue.

[modern paradox]

Yeah Jack, i have tested the console many different times trying many different things, it gives me the "Access denied error" in the console after i enter the correct password.

[SpiritWebb]

Try this:

http://www.wampserver.com/phorum/read.php?2,63652

[Chris]

Then by the sounds of it you're using the wrong password .

[modern paradox]

Try this:

http://www.wampserver.com/phorum/read.php?2,63652

Unfortunately i tried this already and it did not work "nor did his password.reset app", i have tried many different things from many different sites.

Then by the sounds of it you're using the wrong password .

Nah man, i simply set the password to root, so that i had a password to give the config file for ProjectBattle.


I honestly have no clue why it will not accept the password i set for it and then give me an error saying im not using a password, then set a password for it manually in the phpmyadmin config.inc and continue to give me a new error that tells me im now using a password -.- "and that password should be root" :O



EDIT. Ok i think im done trying to fix WAMP and instead i have downloaded an alternative called EasyPHP and it works just as well as WAMP only it will not detect my static IP like WAMP did, but thats not a big deal since i don't think i will ever actually use my little 1201n netbook as a webhost lol. (I do appreciate all you guys trying to help me!! )

[Chris]

Have you tried connect to your MySQL server using the command line or through another program, maybe even a simple PHP script? You might have to set the default password in your php.ini.

mysql.default_password

[modern paradox]

Have you tried connect to your MySQL server using the command line or through another program, maybe even a simple PHP script? You might have to set the default password in your php.ini.

mysql.default_password

Yup, i stated a little while ago that i had tried the mySQL command line and received an access denied error, after i had played with the settings using tutorials on a few sites.