Articles in this section

See more

Cannot open phpMyAdmin for the database in Plesk: Access denied for user

Avatar
Mikhail Shport
Updated
Follow
Plesk for Windows Plesk for Linux kb: technical ABT: Group B

Applicable to:

  • Plesk for Linux
  • Plesk for Windows

Symptoms

  • phpMyAdmin shows the following errors on attempt to access the database through Plesk at Domains > example.com > Databases > exampledb > phpMyAdmin:

    CONFIG_TEXT: Connection for exampleuser as defined in your configuration failed

    CONFIG_TEXT: You probably did not create a configuration file. You might want to use the setup script to create one.

    Error
    MySQL said:

    #1045 - Access denied for user 'exampleuser'@'localhost' (using password: YES)
    mysqli_real_connect(): (HY000/1045): Access denied for user 'exampleuser'@'localhost' (using password: YES)

  • Repair Kit error:

    CONFIG_TEXT: The user johndoe on the subscription example.com is unable to connect to the database server.

Cause

Password for the database user was modified directly in the database server, therefore Plesk has outdated password stored for the phpMyAdmin connections.

Resolution

Password for the database user should be updated in Plesk:

Note: In case any applications are using this database, the new password must match the one specified in the next steps.

Updating the password using Plesk UI:
  1. Log into Plesk
  2. Navigate to the Domains > example.com > Databases > User Management > exampleuser
  3. Specify a new password, or click on the Generate button
  4. Click on Ok
Updating the password using Plesk CLI:

  1. Connect to the server via SSH or RDP

  2. Run the following command in the console:

    # plesk bin database --update-dbuser exampleuser -passwd 'new_password' -server localhost:3306

    Note: In case password for the remote database user should be updated, its host and port should be specified instead in the -server option.

Comments

2 comments

Sort by Date Votes
  • Avatar
    JuJue Holistic Wellness

    Hm, ...wondering

    Before, with WHM, no problem at all, easy access all databases via phpMyAdmin.

    Now after I'd moved to Plesk, within one domain I can:

    1. access 2 databases with phpMyAdmin without any problem
    2. access another 2 databases but need to Login
    3. not access the 5th databases as it throws me an access denied

    I try to wrap my brain around that puzzle but am unable to come up with an explanation.

    Thanks

    1
    Comment actions Permalink
  • Avatar
    JuJue Holistic Wellness

    Figured it out.

    IC, MySQL on Plesk behaves totally different.

    I went into user management of One database, which always asked me for login details when trying to access phpMyAdmin within Plesk, and tried to change password (very slightly, though) and the I couldn't save it. Got a warning the the password is too weak, according to MySQL rules.

    AHA, there we go. Changed it to a complete different PW but Most Important, at a strength level MySQL could accept and look at that, Now I can access the database using the phpMyAdmin link in Plesk.

    A simple solution but one needs to know that.

    Admin, perhaps you can use this info for the other people with the same or similar issue.

    You may mark this post as solved.

    Cheers.

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request

Related articles