Page 1 of 1
WAMP, PHPmyAdmin issues
Posted: Mon Oct 25, 2010 4:27 pm
by 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 ?
Re: WAMP, PHPmyAdmin issues
Posted: Mon Oct 25, 2010 5:00 pm
by 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.
Re: WAMP, PHPmyAdmin issues
Posted: Mon Oct 25, 2010 5:08 pm
by 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.
Re: WAMP, PHPmyAdmin issues
Posted: Mon Oct 25, 2010 6:01 pm
by 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.
Re: WAMP, PHPmyAdmin issues
Posted: Mon Oct 25, 2010 6:33 pm
by 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.
Re: WAMP, PHPmyAdmin issues
Posted: Mon Oct 25, 2010 9:37 pm
by SpiritWebb
Re: WAMP, PHPmyAdmin issues
Posted: Mon Oct 25, 2010 9:38 pm
by Chris
Then by the sounds of it you're using the wrong password
.
Re: WAMP, PHPmyAdmin issues
Posted: Mon Oct 25, 2010 10:36 pm
by modern paradox
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.
Chris wrote: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!! 
)
Re: WAMP, PHPmyAdmin issues
Posted: Mon Oct 25, 2010 10:54 pm
by 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
Re: WAMP, PHPmyAdmin issues
Posted: Mon Oct 25, 2010 10:58 pm
by modern paradox
Chris wrote: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.