View previous topic :: View next topic |
Author |
Message |
ncwdavid -
Joined: 07 Aug 2007 Posts: 30
|
Posted: Tue Aug 07, 2007 5:03 pm Post subject: Access denied for user: 'root@localhost' (Using password: NO |
|
|
Hey, I got phpMyAdmin and mysql working perfectly. Then I saw that user "root" had full privilegdes but no password so I put a password on that user. Now when i got to phpMyAdmin I got this error: "Access denied for user: 'root@localhost' (Using password: NO) " and above it I get:
"Welcome to phpMyAdmin 2.8.0.3
Probably reason of this is that you did not create configuration file. You might want to use setup script to create one."
Does anyone know how to fix this? Thanks! |
|
Back to top |
|
|
Moxxnixx -
Joined: 21 Jun 2003 Posts: 1226 Location: Florida
|
Posted: Tue Aug 07, 2007 5:08 pm Post subject: |
|
|
ncwdavid, welcome to the forums.
Did you put the same password in the config.inc.php file? |
|
Back to top |
|
|
ncwdavid -
Joined: 07 Aug 2007 Posts: 30
|
Posted: Tue Aug 07, 2007 5:26 pm Post subject: |
|
|
Moxxnixx wrote: | ncwdavid, welcome to the forums.
Did you put the same password in the config.inc.php file? |
No? So where do I find this file? and what do I do? |
|
Back to top |
|
|
AbyssUnderground -
Joined: 31 Dec 2004 Posts: 3855
|
|
Back to top |
|
|
ncwdavid -
Joined: 07 Aug 2007 Posts: 30
|
Posted: Tue Aug 07, 2007 5:32 pm Post subject: |
|
|
Yeah thats what I used and for PHP and for MySql and phpmyadmin was working til I added a password to the user "root"? It wont even ask me to login to it. |
|
Back to top |
|
|
AbyssUnderground -
Joined: 31 Dec 2004 Posts: 3855
|
Posted: Tue Aug 07, 2007 5:33 pm Post subject: |
|
|
ncwdavid wrote: |
Yeah thats what I used and for PHP and for MySql and phpmyadmin was working til I added a password to the user "root"? It wont even ask me to login to it. |
Clear your cookies and make sure you set the configuration to say "cookie" like it tells you to. _________________ Andy (AbyssUnderground) (previously The Inquisitor)
www.abyssunderground.co.uk |
|
Back to top |
|
|
ncwdavid -
Joined: 07 Aug 2007 Posts: 30
|
Posted: Tue Aug 07, 2007 5:37 pm Post subject: |
|
|
AbyssUnderground wrote: | ncwdavid wrote: |
Yeah thats what I used and for PHP and for MySql and phpmyadmin was working til I added a password to the user "root"? It wont even ask me to login to it. |
Clear your cookies and make sure you set the configuration to say "cookie" like it tells you to. |
Done that and it doesnt work. |
|
Back to top |
|
|
AbyssUnderground -
Joined: 31 Dec 2004 Posts: 3855
|
Posted: Tue Aug 07, 2007 5:39 pm Post subject: |
|
|
ncwdavid wrote: | AbyssUnderground wrote: | ncwdavid wrote: |
Yeah thats what I used and for PHP and for MySql and phpmyadmin was working til I added a password to the user "root"? It wont even ask me to login to it. |
Clear your cookies and make sure you set the configuration to say "cookie" like it tells you to. |
Done that and it doesnt work. |
Are you sure you changed the correct file? Only other option is to delete phpMyAdmin and try again. You won't lose your databases so don't worry. _________________ Andy (AbyssUnderground) (previously The Inquisitor)
www.abyssunderground.co.uk |
|
Back to top |
|
|
ncwdavid -
Joined: 07 Aug 2007 Posts: 30
|
Posted: Tue Aug 07, 2007 5:41 pm Post subject: |
|
|
Ok thanks I will try that now. Does that mean re editing the phpmyadmin config file again? |
|
Back to top |
|
|
AbyssUnderground -
Joined: 31 Dec 2004 Posts: 3855
|
Posted: Tue Aug 07, 2007 5:42 pm Post subject: |
|
|
ncwdavid wrote: | Ok thanks I will try that now. Does that mean re editing the phpmyadmin config file again? |
Yes but there isn't much to edit. Just a few settings. Follow the tutorial exactly as it states and it will work fine. _________________ Andy (AbyssUnderground) (previously The Inquisitor)
www.abyssunderground.co.uk |
|
Back to top |
|
|
ncwdavid -
Joined: 07 Aug 2007 Posts: 30
|
Posted: Tue Aug 07, 2007 5:46 pm Post subject: |
|
|
AbyssUnderground wrote: | ncwdavid wrote: | Ok thanks I will try that now. Does that mean re editing the phpmyadmin config file again? |
Yes but there isn't much to edit. Just a few settings. Follow the tutorial exactly as it states and it will work fine. |
Ok done editing but the same thing still. Maybe reinstall mysql? |
|
Back to top |
|
|
AbyssUnderground -
Joined: 31 Dec 2004 Posts: 3855
|
Posted: Tue Aug 07, 2007 5:48 pm Post subject: |
|
|
ncwdavid wrote: | AbyssUnderground wrote: | ncwdavid wrote: | Ok thanks I will try that now. Does that mean re editing the phpmyadmin config file again? |
Yes but there isn't much to edit. Just a few settings. Follow the tutorial exactly as it states and it will work fine. |
Ok done editing but the same thing still. Maybe reinstall mysql? |
Reset your MySQL password. Find my.ini on your hard disk and remove it (or edit the password, I can't remember if its in plain text or not) _________________ Andy (AbyssUnderground) (previously The Inquisitor)
www.abyssunderground.co.uk |
|
Back to top |
|
|
ncwdavid -
Joined: 07 Aug 2007 Posts: 30
|
Posted: Tue Aug 07, 2007 5:55 pm Post subject: |
|
|
Ok I just reinstalled mysql and it works fine. I dont get asked for a password when i point my browser to phpmyadmin. The user "root" still has no password and has all priveledges but I dont want to give it a password like the last time and mess it all up again so what will i do? delete "root"? and create a new user? |
|
Back to top |
|
|
AbyssUnderground -
Joined: 31 Dec 2004 Posts: 3855
|
Posted: Tue Aug 07, 2007 5:57 pm Post subject: |
|
|
ncwdavid wrote: | Ok I just reinstalled mysql and it works fine. I dont get asked for a password when i point my browser to phpmyadmin. The user "root" still has no password and has all priveledges but I dont want to give it a password like the last time and mess it all up again so what will i do? delete "root"? and create a new user? |
You should get asked for a password if you have set up the config file correctly. Did you copy and paste it and rename it as the tutorial says to do? _________________ Andy (AbyssUnderground) (previously The Inquisitor)
www.abyssunderground.co.uk |
|
Back to top |
|
|
ncwdavid -
Joined: 07 Aug 2007 Posts: 30
|
Posted: Tue Aug 07, 2007 5:57 pm Post subject: |
|
|
AbyssUnderground wrote: | ncwdavid wrote: | Ok I just reinstalled mysql and it works fine. I dont get asked for a password when i point my browser to phpmyadmin. The user "root" still has no password and has all priveledges but I dont want to give it a password like the last time and mess it all up again so what will i do? delete "root"? and create a new user? |
You should get asked for a password if you have set up the config file correctly. Did you copy and paste it and rename it as the tutorial says to do? |
Yeah |
|
Back to top |
|
|
AbyssUnderground -
Joined: 31 Dec 2004 Posts: 3855
|
Posted: Tue Aug 07, 2007 5:59 pm Post subject: |
|
|
Then you should get asked for a username and password as stated in the screenshot. Can you post your copy of the highlighted lines in the tutorial please? This well help me to determine the problem. Also post the exact filename of the file you post each piece of code from. _________________ Andy (AbyssUnderground) (previously The Inquisitor)
www.abyssunderground.co.uk |
|
Back to top |
|
|
ncwdavid -
Joined: 07 Aug 2007 Posts: 30
|
Posted: Tue Aug 07, 2007 5:59 pm Post subject: |
|
|
I took the ".php" off the end of it since it was already saved as a .php file and i get asked for a password and username now. So does that mean its working ok? |
|
Back to top |
|
|
AbyssUnderground -
Joined: 31 Dec 2004 Posts: 3855
|
Posted: Tue Aug 07, 2007 6:01 pm Post subject: |
|
|
ncwdavid wrote: | I took the ".php" off the end of it since it was already saved as a .php file and i get asked for a password and username now. So does that mean its working ok? |
It should do yes. You didnt save it as config.inc.php.php did you? _________________ Andy (AbyssUnderground) (previously The Inquisitor)
www.abyssunderground.co.uk |
|
Back to top |
|
|
ncwdavid -
Joined: 07 Aug 2007 Posts: 30
|
Posted: Tue Aug 07, 2007 6:04 pm Post subject: |
|
|
AbyssUnderground wrote: | ncwdavid wrote: | I took the ".php" off the end of it since it was already saved as a .php file and i get asked for a password and username now. So does that mean its working ok? |
It should do yes. You didnt save it as config.inc.php.php did you? |
Yeah I did I added the extra .php at the end. Ok I have cookies enabled and I am trying to login but it wont let me. I am using the correct details because I can see them right in front of me in the mysql my.ini setup page? |
|
Back to top |
|
|
AbyssUnderground -
Joined: 31 Dec 2004 Posts: 3855
|
Posted: Tue Aug 07, 2007 6:05 pm Post subject: |
|
|
OK problem solved. If its not the correct filename it won't see it :-)
Are you positive its right?
Remember its case sensetive. _________________ Andy (AbyssUnderground) (previously The Inquisitor)
www.abyssunderground.co.uk |
|
Back to top |
|
|
ncwdavid -
Joined: 07 Aug 2007 Posts: 30
|
Posted: Tue Aug 07, 2007 6:07 pm Post subject: |
|
|
AbyssUnderground wrote: | OK problem solved. If its not the correct filename it won't see it :-)
Are you positive its right?
Remember its case sensetive. |
Ok still not working and then I tried it with:
username: root
password:
I didnt put in a password and it logged me in even tho when it wouldnt let me login with username "root" it said using password YES. What does this mean? |
|
Back to top |
|
|
AbyssUnderground -
Joined: 31 Dec 2004 Posts: 3855
|
Posted: Tue Aug 07, 2007 6:10 pm Post subject: |
|
|
Because your config file wasnt "there" according to phpmyadmin it won't let you log in for security reasons.
If you have a root password, enter it and you will log in. If you dont have one, don't enter it and it should log in.
Obviously if you have no password set you cant enter one and expect it to log in.
Using password YES means you're using a password as appose to a blank password. _________________ Andy (AbyssUnderground) (previously The Inquisitor)
www.abyssunderground.co.uk |
|
Back to top |
|
|
ncwdavid -
Joined: 07 Aug 2007 Posts: 30
|
Posted: Tue Aug 07, 2007 6:14 pm Post subject: |
|
|
Yess!! I went in with no password and then added one and now if I try and login with no password it doesnt work and It works with the new password!! Thanks!!!! |
|
Back to top |
|
|
|