Results 1 to 12 of 12

Thread: acces phpmyadmin asking username and password

  1. #1
    Registered Member
    Join Date
    Apr 2008
    Posts
    10

    Default acces phpmyadmin asking username and password

    usually if i acces phpmyadmin from cpanel, it always directly to phpmyadmin page, but suddenly if i acces phpmyadmin it asking username and password ..

    how to fix it, i just want to like usually..

    please advise.

    thx before

  2. #2
    cPanel Product Evangelist Infopro's Avatar
    Join Date
    May 2003
    Location
    Pennsylvania
    Posts
    10,903
    cPanel/WHM Access Level

    Root Administrator

    Lightbulb Re: acces phpmyadmin asking username and password

    The easiest answer is to clear your cache, close all browsers and then give it another try from the start. Also be sure you're not logging into a normal cPanel account as root or reseller.

  3. #3
    Integration Developer cPanelDavidN's Avatar
    Join Date
    Dec 2009
    Location
    Houston, TX
    Posts
    570

    Default Re: acces phpmyadmin asking username and password

    If that doesn't work, then it's likely your account's MySQL password has gotten out of sync with your cPanel account password. Under normal circumstances those passwords are the same, however, the way that phpMyAdmin was loaded in previous versions (cPanel versions before 11.28) it would ensure that the password was synced before loading the application. In 11.28 we removed that auto-syncing functionality and added the login form. In this way, if you're MySQL password is different for a reason, we don't overwrite it, and you can still log into phpMyAdmin.

    If you can put your cPanel username and password into the phpMyAdmin login form and successfully authenticate, then the problem is most certainly just cache related, as InfoPro suggests. This will be the case most of the time.

    Regards,
    -DavidN

    Reference Notes
    - CHANGLOG: Case 43447
    - Release Notes: Changed to phpMyAdmin Authentication
    David Neimeyer
    Integration Developer

    sdk.cpanel.net
    APIs: XML-API API1 & API2
    Check Out: Developer Downloads Integration Blog
    Need Support? Support Ticket Developer Forum Feature Requests

  4. #4
    Registered Member
    Join Date
    Sep 2004
    Posts
    528

    Default Re: acces phpmyadmin asking username and password

    But its a way to avoid this or every time you log to phpmyadmin will ask you the username/password?

    I could log in typing the database username and password.

  5. #5
    cPanel Staff cPanelJared's Avatar
    Join Date
    Feb 2010
    Location
    Houston, TX
    Posts
    1,695
    cPanel/WHM Access Level

    Root Administrator

    Default Re: acces phpmyadmin asking username and password

    If the cPanel user password and MySQL password are not the same, you can try resetting the account password using Main >> Account Functions >> Password Modification. This function will attempt to reset the cPanel user password for the system and MySQL. This should result in the system password and MySQL password again being in sync, preventing the phpMyAdmin log-in page.

    If you are able to log into phpMyAdmin using the existing cPanel username and password, then clearing the browser cache should help. If it does not, please submit a ticket so that we may investigate the problem directly on your server and offer more specific advice.
    For hands-on assistance, please reference our new support information page: Where should I go for support?
    cPResources: Support Options - Submit a ticket here - Additional Support Options - Forums Search - Mailing Lists(Alt) - Documentation - Find cPanel hosting


    -- Jared Ryan, Technical Analyst, cPanel Technical Support

  6. #6
    Registered Member
    Join Date
    May 2005
    Location
    Auburn, CA
    Posts
    297
    cPanel/WHM Access Level

    Root Administrator

    Default Re: acces phpmyadmin asking username and password

    I've never set a different password for MySQL than for my (own personal) cPanel account, and even after the upgrade to 11.28 on what used to be known as the RELEASE tree, I could always automatically go to PHPMyAdmin from within cPanel. With last night's upgrade to 11.28.87 this is changed.

    My cPanel username and password are not working in the PHPMyAdmin login form.

    EDIT: And as for the annoying "stock suggestion" of clearing your browser cache... #1, I have cache disabled in my main browser, and #2 I also tried logging in from a browser I have never accessed cPanel from. Same login problem.
    Last edited by MaraBlue; 03-22-2011 at 03:05 PM.
    cPanel: Latest RELEASE Version [11.42.x]
    PHP 5.3.27, Apache 2.2.26, MySQL 5.1.70, Perl 5.10.1, CentOS 6.4 64-bit

  7. #7
    Registered Member
    Join Date
    May 2005
    Location
    Auburn, CA
    Posts
    297
    cPanel/WHM Access Level

    Root Administrator

    Default Re: acces phpmyadmin asking username and password

    And yes, I'm logged in as the user, not root.

    EDIT: Changing the cPanel password, then changing it back, worked. Of course by now I've forgotten why I was trying to login to PHPMyAdmin in the first place...
    Last edited by MaraBlue; 03-22-2011 at 03:20 PM. Reason: fixed
    cPanel: Latest RELEASE Version [11.42.x]
    PHP 5.3.27, Apache 2.2.26, MySQL 5.1.70, Perl 5.10.1, CentOS 6.4 64-bit

  8. #8
    Registered Member cPanel Partner NOC Badge
    Join Date
    Jan 2006
    Posts
    718

    Default Re: acces phpmyadmin asking username and password

    Can I ask - under what circumstance would the user's mysql password be different from the cpanel password? I'm not aware of any option they may have of changing it.

  9. #9
    cPanel Development cPanelKenneth's Avatar
    Join Date
    Apr 2006
    Posts
    4,236
    cPanel/WHM Access Level

    Root Administrator

    Default Re: acces phpmyadmin asking username and password

    Quote Originally Posted by 4u123 View Post
    Can I ask - under what circumstance would the user's mysql password be different from the cpanel password? I'm not aware of any option they may have of changing it.
    This used to be a manual operation performed by a system admin. Typically this was/is for users who use their main cPanel account for the MySQL access credentials when configuring something like wordpress. Making the passwords distinct prevented an exploit in something like wordpress from giving the perp access to the cPanel account.
    Kenneth
    Development
    cPanel, Inc.

  10. #10
    ckh
    ckh is offline
    Registered Member
    Join Date
    Dec 2003
    Location
    Phoenix, AZ
    Posts
    355
    cPanel/WHM Access Level

    DataCenter Provider

    Default Re: acces phpmyadmin asking username and password

    I used WHM's transfer to transfer 2 sites and ran into the phpMyAdmin login problem. Changing the cPanel password worked for both.

    However... I'm also receiving the login form when I try to access phpMyAdmin from WHM. Tried changing the root password and that didn't do it. How would I go about getting rid of the login form from WHM?

  11. #11
    cPanel Staff cPanelTristan's Avatar
    Join Date
    Oct 2010
    Location
    somewhere over the rainbow
    Posts
    7,610
    cPanel/WHM Access Level

    Root Administrator

    Default Re: acces phpmyadmin asking username and password

    Hello ckh,

    Could you try running the following script to see the results:

    Code:
    /usr/local/cpanel/bin/updatephpmyadmin --force
    If this does not work, please see if you can even get into MySQL command line:

    Code:
    mysql
    mysqladmin proc
    If both return an error about root@localhost, please post the error message. This would indicate an issue with MySQL functioning properly for the root user to connect with the /root/.my.cnf password set (please do not change the root password manually in the /root/.my.cnf file at any time, since this does not change it in MySQL itself).

    Thanks!
    cPResources: Support Options | More Support Options | Forums Search | cPanel.net Site Search | Mailing Lists(Alt) | Docs
    -- Tristan, Technical Analyst III, Forums Specialist, cPanel Tech Support

    Submit a ticket | Check an existing ticket

  12. #12
    ckh
    ckh is offline
    Registered Member
    Join Date
    Dec 2003
    Location
    Phoenix, AZ
    Posts
    355
    cPanel/WHM Access Level

    DataCenter Provider

    Default Re: acces phpmyadmin asking username and password

    Odd, I had already ran that and it didn't have any affect. Tried it today and it all seems well now. Thanks!

Similar Threads

  1. Wrong username/password. Access denied phpmyadmin
    By vishal3184 in forum Database Discussions
    Replies: 5
    Last Post: 06-27-2012, 02:30 PM
  2. phpMyAdmin error: Wrong username/password. Access denied.
    By irchs in forum cPanel & WHM Discussions
    Replies: 11
    Last Post: 07-27-2005, 07:52 PM
  3. Users' PhpMyAdmin - Wrong username/password
    By protocol in forum cPanel & WHM Discussions
    Replies: 1
    Last Post: 03-30-2005, 07:59 PM
  4. phpMyAdmin Wrong username/password. Access denied.
    By LP-Trel in forum cPanel & WHM Discussions
    Replies: 3
    Last Post: 03-17-2004, 02:26 AM
  5. phpmyadmin...Wrong username/password. Access denied.
    By smarcellini in forum cPanel & WHM Discussions
    Replies: 13
    Last Post: 02-08-2004, 08:33 PM
bargain