User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the PHP section within the Web Development category of DaniWeb, a massive community of 425,954 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 1,622 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our PHP advertiser: Lunarpages PHP Web Hosting
Views: 1817 | Replies: 36 | Solved
Reply
Join Date: Sep 2006
Posts: 90
Reputation: scorpionz is an unknown quantity at this point 
Rep Power: 3
Solved Threads: 0
scorpionz scorpionz is offline Offline
Junior Poster in Training

phpmyadmin issue

  #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
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Nov 2007
Location: Las Vegas, Nevada
Posts: 83
Reputation: johnsquibb is an unknown quantity at this point 
Rep Power: 1
Solved Threads: 14
johnsquibb's Avatar
johnsquibb johnsquibb is offline Offline
Junior Poster in Training

Re: phpmyadmin issue

  #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  
Join Date: Nov 2007
Location: Bangalore, India
Posts: 3,098
Reputation: nav33n has a spectacular aura about nav33n has a spectacular aura about 
Rep Power: 8
Solved Threads: 240
nav33n's Avatar
nav33n nav33n is offline Offline
Posting Sensei

Re: phpmyadmin issue

  #3  
Feb 14th, 2008
Grant privileges (using root account) to the user pma. I don't think pma have sufficient privileges.
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.

*PM asking for help will be ignored*
Reply With Quote  
Join Date: Sep 2006
Posts: 90
Reputation: scorpionz is an unknown quantity at this point 
Rep Power: 3
Solved Threads: 0
scorpionz scorpionz is offline Offline
Junior Poster in Training

Re: phpmyadmin issue

  #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  
Join Date: Nov 2007
Location: Bangalore, India
Posts: 3,098
Reputation: nav33n has a spectacular aura about nav33n has a spectacular aura about 
Rep Power: 8
Solved Threads: 240
nav33n's Avatar
nav33n nav33n is offline Offline
Posting Sensei

Re: phpmyadmin issue

  #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 !
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.

*PM asking for help will be ignored*
Reply With Quote  
Join Date: Jan 2008
Posts: 55
Reputation: Walkere is an unknown quantity at this point 
Rep Power: 1
Solved Threads: 5
Walkere Walkere is offline Offline
Junior Poster in Training

Re: phpmyadmin issue

  #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  
Join Date: Sep 2006
Posts: 90
Reputation: scorpionz is an unknown quantity at this point 
Rep Power: 3
Solved Threads: 0
scorpionz scorpionz is offline Offline
Junior Poster in Training

Cant Solve

  #7  
Feb 15th, 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  
Join Date: Nov 2007
Location: Bangalore, India
Posts: 3,098
Reputation: nav33n has a spectacular aura about nav33n has a spectacular aura about 
Rep Power: 8
Solved Threads: 240
nav33n's Avatar
nav33n nav33n is offline Offline
Posting Sensei

Re: phpmyadmin issue

  #8  
Feb 16th, 2008
Can you log in with 'root' account ?
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.

*PM asking for help will be ignored*
Reply With Quote  
Join Date: Sep 2006
Posts: 90
Reputation: scorpionz is an unknown quantity at this point 
Rep Power: 3
Solved Threads: 0
scorpionz scorpionz is offline Offline
Junior Poster in Training

No i cant

  #9  
Feb 16th, 2008
I cant event log in through root...
I dont know What to do?????
Regards
Scorpion
Reply With Quote  
Join Date: Nov 2007
Location: Bangalore, India
Posts: 3,098
Reputation: nav33n has a spectacular aura about nav33n has a spectacular aura about 
Rep Power: 8
Solved Threads: 240
nav33n's Avatar
nav33n nav33n is offline Offline
Posting Sensei

Re: phpmyadmin issue

  #10  
Feb 16th, 2008
hmm.. Check this . It might be of some help.
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.

*PM asking for help will be ignored*
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

DaniWeb PHP Marketplace
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

Thread Tools Display Modes

Similar Threads
Other Threads in the PHP Forum

All times are GMT -4. The time now is 10:30 pm.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC