Skip to main content

Phpmyadmin asking for username and password when login through user cPanel.

Comments

12 comments

  • kjg
    Hi We have had this issue a number of times and the reason has been password problems. Changing the cpanel password (and that way also mysql password) have solved it for us each time. Hope this helps.
    0
  • l2Support
    Thanks.. unfortunately that is not helping.. following is the error from cpanel error logs :
    [2016-02-03 15:02:20 +0530] warn [cpmysql] Error from MySQL query: (XID q9p6tf) DBD::mysql::db do failed: The password hash doesn't have the expected format. Check if the correct password algorithm is being used with the PASSWORD() function. at /usr/local/cpanel/Cpanel/Mysql.pm line 1533. Cpanel::Mysql::_dbowner_to_all_with_ownership_checks(Cpanel::Mysql=HASH(0x1943d18), "method", "GRANT", "users", HASH(0x14f69a8)) called at /usr/local/cpanel/Cpanel/Mysql.pm line 761 Cpanel::Mysql::updateprivs(Cpanel::Mysql=HASH(0x1943d18)) called at bin/admin/Cpanel/cpmysql.pl line 181
    0
  • cPanelMichael
    Hello :) Check to see if the "mysql_old_format" plugin is configured for this user with a command such as:
    mysql -e 'select user, length(Password), plugin from mysql.user WHERE user="$username";'
    If so, you can update this with commands such as:
    mysql mysql > use mysql; mysql> update user set Plugin = 'mysql_native_password' where Plugin = 'mysql_old_password';
    Then, change the password of the account again, and let us know if the issue persists after clearing your browser cache. Thank you.
    0
  • l2Support
    Hello :) Check to see if the "mysql_old_format" plugin is configured for this user with a command such as:
    mysql -e 'select user, length(Password), plugin from mysql.user WHERE user="$username";'
    If so, you can update this with commands such as:
    mysql> update user set Plugin = 'mysql_native_password' where Plugin = 'mysql_old_password';
    Then, change the password of the account again, and let us know if the issue persists after clearing your browser cache. Thank you.

    Thanks a lot !! :) that worked !! cheerz.
    0
  • cPanelMichael
    I am happy to see it helped. Thank you for updating us with the outcome.
    0
  • em.ci
    Hello :) Check to see if the "mysql_old_format" plugin is configured for this user with a command such as:
    mysql -e 'select user, length(Password), plugin from mysql.user WHERE user="$username";'
    If so, you can update this with commands such as:
    mysql> update user set Plugin = 'mysql_native_password' where Plugin = 'mysql_old_password';
    Then, change the password of the account again, and let us know if the issue persists after clearing your browser cache. Thank you.

    Hi Michael If I try to update the cpanel user with this command i recieve the error: ERROR 1046 (3D000): No database selected Any ideas what could be the problem? Thanks, emci
    0
  • cPanelMichael
    Any ideas what could be the problem?


    mysql mysql > use mysql; mysql > update user set Plugin = 'mysql_native_password' where Plugin = 'mysql_old_password';
    I've updated the commands to show how to use the "mysql" database. Thank you.
    0
  • em.ci

    mysql mysql > use mysql; mysql > update user set Plugin = 'mysql_native_password' where Plugin = 'mysql_old_password';
    I've updated the commands to show how to use the "mysql" database. Thank you.

    Hi Michael, Thanks for the Update. So am I right that this command updates every mysql user with the old password hash on the server? Thanks, emci
    0
  • em.ci
    I have still a problem with the database users. When I try to change the user password I receive the following error:
    (XID qdku4t) DBD::mysql::db do failed: Password hash should be a 16-digit hexadecimal number
    I checked the user with the following command:
    mysql -e 'select user, length(Password), plugin from mysql.user WHERE user="user1_db";'
    Then I received the following output:
    +----------+------------------+--------------------+ | user | length(Password) | plugin | +----------+------------------+--------------------+ | user1_db | 16 | mysql_old_password | | user1_db | 16 | mysql_old_password | | user1_db | 16 | mysql_old_password | +----------+------------------+--------------------+
    Then I used the following command to change the plugin format:
    mysql mysql > use mysql; mysql > update user set Plugin = 'mysql_native_password' where Plugin = 'mysql_old_password';
    Now the output looks like this:
    +-----------+------------------+-----------------------+ | user | length(Password) | plugin | +-----------+------------------+-----------------------+ | user1_db | 16 | mysql_native_password | | user1_db | 16 | mysql_native_password | | user1_db | 16 | mysql_native_password | +-----------+------------------+-----------------------+
    But I still get the same error message. So is there any way to change the "lenght(Password) from 16 to 41? Thanks, emci
    0
  • cPanelMichael
    But I still get the same error message. So is there any way to change the "lenght(Password) from 16 to 41?

    Hello, Did you change the password for the user after updating the plugin format? Thank you.
    0
  • em.ci
    Hello, Did you change the password for the user after updating the plugin format? Thank you.

    Hi Michael, Yes I changed the password and I received the same error message. But now it is working. I had to restart mysql first and then change the password.
    0
  • cPanelMichael
    Yes I changed the password and I received the same error message. But now it is working. I had to restart mysql first and then change the password.

    I'm happy to see the issue is now resolved. Thank you for updating us with the outcome.
    0

Please sign in to leave a comment.