phpmyadmin issue

Thread Solved

Join Date: Sep 2006
Posts: 107
Reputation: scorpionz is an unknown quantity at this point 
Solved Threads: 0
scorpionz scorpionz is offline Offline
Junior Poster

phpmyadmin issue

 
1
  #1
Feb 14th, 2008
Hi This is Scorp

I have Little issue about phpmyadmin.

When i write
http://localhost/phpmyadmin
on my url and Press Enter
i got the Login Screen
and i tries every username and password, but everytime it gives same error

Error
MySQL said:
#1045 - Access denied for user 'pma'@'localhost' (using password: YES)

I m stuck
Any help will be Appriciated
Regards Scorpion
Reply With Quote Quick reply to this message  
Join Date: Nov 2007
Posts: 84
Reputation: johnsquibb is an unknown quantity at this point 
Solved Threads: 14
johnsquibb's Avatar
johnsquibb johnsquibb is offline Offline
Junior Poster in Training

Re: phpmyadmin issue

 
0
  #2
Feb 14th, 2008
i assume you have root access to the server to set configurations etc....

I am not a phpmyadmin maestro, so you might be better off posting this in a linux/wamp forum depending on your server type...I can just suggest a few troubleshooting techniques that I have come across in my experience.
--
is mysql running?
--
have you set a password for mysql root user yet? If not, enter a username without password. More on mysql passwords here: http://dev.mysql.com/doc/refman/5.0/...ing-users.html
---
have you set up the phpmyadmin config? This can be a royal pain. Be sure to refer to the documentation here: http://wiki.cihar.com/pma/Welcome_to_phpMyAdmin_Wiki. Quick Install->configuration is a good place to start.
The End
Reply With Quote Quick reply to this message  
Join Date: Nov 2007
Posts: 3,761
Reputation: nav33n is a jewel in the rough nav33n is a jewel in the rough nav33n is a jewel in the rough 
Solved Threads: 332
Moderator
Featured Poster
nav33n's Avatar
nav33n nav33n is offline Offline
Senior Poster

Re: phpmyadmin issue

 
0
  #3
Feb 14th, 2008
Grant privileges (using root account) to the user pma. I don't think pma have sufficient privileges.
Ignorance is definitely not bliss!

*PM asking for help will be ignored*
Reply With Quote Quick reply to this message  
Join Date: Sep 2006
Posts: 107
Reputation: scorpionz is an unknown quantity at this point 
Solved Threads: 0
scorpionz scorpionz is offline Offline
Junior Poster

Re: phpmyadmin issue

 
0
  #4
Feb 14th, 2008
So Guys How can i Fix this issue so as to get through to my wprk
Regards
Scorpion
Reply With Quote Quick reply to this message  
Join Date: Nov 2007
Posts: 3,761
Reputation: nav33n is a jewel in the rough nav33n is a jewel in the rough nav33n is a jewel in the rough 
Solved Threads: 332
Moderator
Featured Poster
nav33n's Avatar
nav33n nav33n is offline Offline
Senior Poster

Re: phpmyadmin issue

 
0
  #5
Feb 14th, 2008
If you have root password, login with ur root account, create or grant privileges to a user. Check mysql manual for more information !
Ignorance is definitely not bliss!

*PM asking for help will be ignored*
Reply With Quote Quick reply to this message  
Join Date: Jan 2008
Posts: 57
Reputation: Walkere is an unknown quantity at this point 
Solved Threads: 5
Walkere Walkere is offline Offline
Junior Poster in Training

Re: phpmyadmin issue

 
0
  #6
Feb 14th, 2008
Originally Posted by scorpionz View Post
So Guys How can i Fix this issue so as to get through to my wprk
Well, the best way to do that would be to remember the password you used.

In lieu of that, you can log in as the root user and modify the password for the user 'pma' to something new.

Here's how you do this in phpmyadmin, once you're logged in as the "root" account.
  • Click on "Privileges" tab
  • Find username 'pma' in the list
  • Click on the "Edit Privileges" icon all the way to the right
  • Scroll down to where it says "Change Password"
  • Select "Password" and enter a new password
If you don't know the password for the "root" account, you can re-set the password and then use the root account to reset the 'pma' account. Here's the relevant section of the mySQL documentation on re-setting the root password.

Good luck,
- Walkere
Reply With Quote Quick reply to this message  
Join Date: Sep 2006
Posts: 107
Reputation: scorpionz is an unknown quantity at this point 
Solved Threads: 0
scorpionz scorpionz is offline Offline
Junior Poster

Cant Solve

 
0
  #7
Feb 16th, 2008
Sorry to say Guys, i am unable to solve the issue of login to phpmyadmin, let me give you more detail about my problem
I tried with every username and every password but but but nothing is working it is not logging, every time it generates same error,

Error
MySQL said:
#1045 - Access denied for user 'pma'@'localhost' (using password: YES)

I m stuck Guys.....

if any one can give some stepwise working scenario about setting username and password so i can start it phpmyadmin...

Regards
Scorpion
Reply With Quote Quick reply to this message  
Join Date: Nov 2007
Posts: 3,761
Reputation: nav33n is a jewel in the rough nav33n is a jewel in the rough nav33n is a jewel in the rough 
Solved Threads: 332
Moderator
Featured Poster
nav33n's Avatar
nav33n nav33n is offline Offline
Senior Poster

Re: phpmyadmin issue

 
0
  #8
Feb 16th, 2008
Can you log in with 'root' account ?
Ignorance is definitely not bliss!

*PM asking for help will be ignored*
Reply With Quote Quick reply to this message  
Join Date: Sep 2006
Posts: 107
Reputation: scorpionz is an unknown quantity at this point 
Solved Threads: 0
scorpionz scorpionz is offline Offline
Junior Poster

No i cant

 
0
  #9
Feb 16th, 2008
I cant event log in through root...
I dont know What to do?????
Regards
Scorpion
Reply With Quote Quick reply to this message  
Join Date: Nov 2007
Posts: 3,761
Reputation: nav33n is a jewel in the rough nav33n is a jewel in the rough nav33n is a jewel in the rough 
Solved Threads: 332
Moderator
Featured Poster
nav33n's Avatar
nav33n nav33n is offline Offline
Senior Poster

Re: phpmyadmin issue

 
0
  #10
Feb 16th, 2008
hmm.. Check this . It might be of some help.
Ignorance is definitely not bliss!

*PM asking for help will be ignored*
Reply With Quote Quick reply to this message  
Reply

This thread has been marked solved.
Perhaps start a new thread instead?
Message:



Similar Threads
Other Threads in the PHP Forum


Views: 3640 | Replies: 36
Thread Tools Search this Thread



Tag cloud for PHP
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC