Access denied for user: 'root@localhost' (Using password: NO

 
Post new topic   Reply to topic    Aprelium Forum Index -> Databases
View previous topic :: View next topic  
Author Message
ncwdavid
-


Joined: 07 Aug 2007
Posts: 30

PostPosted: Tue Aug 07, 2007 5:03 pm    Post subject: Access denied for user: 'root@localhost' (Using password: NO Reply with quote

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 View user's profile Send private message
Moxxnixx
-


Joined: 21 Jun 2003
Posts: 1226
Location: Florida

PostPosted: Tue Aug 07, 2007 5:08 pm    Post subject: Reply with quote

ncwdavid, welcome to the forums.
Did you put the same password in the config.inc.php file?
Back to top View user's profile Send private message Visit poster's website
ncwdavid
-


Joined: 07 Aug 2007
Posts: 30

PostPosted: Tue Aug 07, 2007 5:26 pm    Post subject: Reply with quote

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 View user's profile Send private message
AbyssUnderground
-


Joined: 31 Dec 2004
Posts: 3855

PostPosted: Tue Aug 07, 2007 5:30 pm    Post subject: Reply with quote

Follow this guide on setting up phpMyAdmin http://www.abyssunderground.co.uk/installing-phpmyadmin.php
_________________
Andy (AbyssUnderground) (previously The Inquisitor)
www.abyssunderground.co.uk
Back to top View user's profile Send private message Visit poster's website
ncwdavid
-


Joined: 07 Aug 2007
Posts: 30

PostPosted: Tue Aug 07, 2007 5:32 pm    Post subject: Reply with quote

AbyssUnderground wrote:
Follow this guide on setting up phpMyAdmin http://www.abyssunderground.co.uk/installing-phpmyadmin.php


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 View user's profile Send private message
AbyssUnderground
-


Joined: 31 Dec 2004
Posts: 3855

PostPosted: Tue Aug 07, 2007 5:33 pm    Post subject: Reply with quote

ncwdavid wrote:
AbyssUnderground wrote:
Follow this guide on setting up phpMyAdmin http://www.abyssunderground.co.uk/installing-phpmyadmin.php


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 View user's profile Send private message Visit poster's website
ncwdavid
-


Joined: 07 Aug 2007
Posts: 30

PostPosted: Tue Aug 07, 2007 5:37 pm    Post subject: Reply with quote

AbyssUnderground wrote:
ncwdavid wrote:
AbyssUnderground wrote:
Follow this guide on setting up phpMyAdmin http://www.abyssunderground.co.uk/installing-phpmyadmin.php


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 View user's profile Send private message
AbyssUnderground
-


Joined: 31 Dec 2004
Posts: 3855

PostPosted: Tue Aug 07, 2007 5:39 pm    Post subject: Reply with quote

ncwdavid wrote:
AbyssUnderground wrote:
ncwdavid wrote:
AbyssUnderground wrote:
Follow this guide on setting up phpMyAdmin http://www.abyssunderground.co.uk/installing-phpmyadmin.php


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 View user's profile Send private message Visit poster's website
ncwdavid
-


Joined: 07 Aug 2007
Posts: 30

PostPosted: Tue Aug 07, 2007 5:41 pm    Post subject: Reply with quote

Ok thanks I will try that now. Does that mean re editing the phpmyadmin config file again?
Back to top View user's profile Send private message
AbyssUnderground
-


Joined: 31 Dec 2004
Posts: 3855

PostPosted: Tue Aug 07, 2007 5:42 pm    Post subject: Reply with quote

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 View user's profile Send private message Visit poster's website
ncwdavid
-


Joined: 07 Aug 2007
Posts: 30

PostPosted: Tue Aug 07, 2007 5:46 pm    Post subject: Reply with quote

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 View user's profile Send private message
AbyssUnderground
-


Joined: 31 Dec 2004
Posts: 3855

PostPosted: Tue Aug 07, 2007 5:48 pm    Post subject: Reply with quote

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 View user's profile Send private message Visit poster's website
ncwdavid
-


Joined: 07 Aug 2007
Posts: 30

PostPosted: Tue Aug 07, 2007 5:55 pm    Post subject: Reply with quote

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 View user's profile Send private message
AbyssUnderground
-


Joined: 31 Dec 2004
Posts: 3855

PostPosted: Tue Aug 07, 2007 5:57 pm    Post subject: Reply with quote

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 View user's profile Send private message Visit poster's website
ncwdavid
-


Joined: 07 Aug 2007
Posts: 30

PostPosted: Tue Aug 07, 2007 5:57 pm    Post subject: Reply with quote

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 View user's profile Send private message
AbyssUnderground
-


Joined: 31 Dec 2004
Posts: 3855

PostPosted: Tue Aug 07, 2007 5:59 pm    Post subject: Reply with quote

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 View user's profile Send private message Visit poster's website
ncwdavid
-


Joined: 07 Aug 2007
Posts: 30

PostPosted: Tue Aug 07, 2007 5:59 pm    Post subject: Reply with quote

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 View user's profile Send private message
AbyssUnderground
-


Joined: 31 Dec 2004
Posts: 3855

PostPosted: Tue Aug 07, 2007 6:01 pm    Post subject: Reply with quote

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 View user's profile Send private message Visit poster's website
ncwdavid
-


Joined: 07 Aug 2007
Posts: 30

PostPosted: Tue Aug 07, 2007 6:04 pm    Post subject: Reply with quote

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 View user's profile Send private message
AbyssUnderground
-


Joined: 31 Dec 2004
Posts: 3855

PostPosted: Tue Aug 07, 2007 6:05 pm    Post subject: Reply with quote

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 View user's profile Send private message Visit poster's website
ncwdavid
-


Joined: 07 Aug 2007
Posts: 30

PostPosted: Tue Aug 07, 2007 6:07 pm    Post subject: Reply with quote

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 View user's profile Send private message
AbyssUnderground
-


Joined: 31 Dec 2004
Posts: 3855

PostPosted: Tue Aug 07, 2007 6:10 pm    Post subject: Reply with quote

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 View user's profile Send private message Visit poster's website
ncwdavid
-


Joined: 07 Aug 2007
Posts: 30

PostPosted: Tue Aug 07, 2007 6:14 pm    Post subject: Reply with quote

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 View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    Aprelium Forum Index -> Databases All times are GMT + 1 Hour
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB phpBB Group