Skip to content
  • Solutions
    By Role
    • For Developers
    • For Content Managers
    • For Agencies
    • For IT Admins
    • For Web Hosters
    • For Developers
    • For Content Managers
    • For Agencies
    • For IT Admins
    • For Web Hosters
    By Infrastructure
    • Overview
    • AWS
    • Microsoft Azure
    • Alibaba Cloud
    • Google Cloud Platform
    • Vultr
    • Overview
    • AWS
    • Microsoft Azure
    • Alibaba Cloud
    • Google Cloud Platform
    • Vultr
    • Digital Ocean
    • Linode
    • Upcloud
    • Oracle
    • OVH
    • Digital Ocean
    • Linode
    • Upcloud
    • Oracle
    • OVH
  • Product
    • Plesk Features
    • Plesk Editions
    • What’s new
    • Pricing
    • Roadmap
    • Lifecycle Policy
    • Extensions Catalogue
  • Pricing
  • Extensions
    Featured Extensions
    • SocialBee
    • WP Toolkit
    • Sitejet Builder for Plesk
    • SEO Toolkit
    • Joomla! Toolkit
    • Premium Email
    • Email Security
    • SocialBee
    • WP Toolkit
    • Sitejet Builder for Plesk
    • SEO Toolkit
    • Joomla! Toolkit
    • Premium Email
    • Email Security
    Bundles and packs:
    • Business and Collaboration Edition
    • WP pack
    • Hosting pack
    • Power pack
    • Language pack
    • Business and Collaboration Edition
    • WP pack
    • Hosting pack
    • Power pack
    • Language pack

    See all Extensions

  • For Partners
    • Plesk Contributor Program
    • Plesk Partner Program
    • Affiliate program
    • Plesk University
  • Help Center
    • Documentation
    • Professional Services
    • Support
    • Contact Us
    • Wiki
    • Forum
  • Plesk 360 login
  • Free Trial
  • Pricing
  • Solutions
    • By Role
      • For Developers
      • For Content Managers
      • For Agencies
      • For IT Admins
      • For Web Hosters
    • By Infrastructure
      • Overview
      • Plesk on Amazon Web Services (AWS & Lightsail)
      • Microsoft Azure
      • Alibaba Cloud
      • Google Cloud Platform
      • Vultr
      • DigitalOcean
      • Linode
      • UpCloud
      • Oracle
      • OVH
  • Products
  • Pricing
  • Extensions
    • Featured Extensions
      • SocialBee
      • WP Toolkit
      • Sitejet Builder for Plesk
      • SEO Toolkit
      • Joomla! Toolkit
      • Premium Email
      • Email Security
    • Bundles and packs:
      • Business and Collaboration Edition
      • WP pack
      • Hosting pack
      • Power pack
      • Language pack
      • See all Extensions
  • For Partners
    • Plesk Contributor Program
    • Plesk Partner Program
    • Affiliate Program
    • Plesk University
  • Help Center
    • Documentation
    • Professional Services
    • Support
    • Contact Us
    • Wiki
    • Forum
  • Plesk 360 login
  • Free Trial
  • Pricing
  • Solutions
    • By Role
      • For Developers
      • For Content Managers
      • For Agencies
      • For IT Admins
      • For Web Hosters
    • By Infrastructure
      • Overview
      • Plesk on Amazon Web Services (AWS & Lightsail)
      • Microsoft Azure
      • Alibaba Cloud
      • Google Cloud Platform
      • Vultr
      • DigitalOcean
      • Linode
      • UpCloud
      • Oracle
      • OVH
  • Products
  • Pricing
  • Extensions
    • Featured Extensions
      • SocialBee
      • WP Toolkit
      • Sitejet Builder for Plesk
      • SEO Toolkit
      • Joomla! Toolkit
      • Premium Email
      • Email Security
    • Bundles and packs:
      • Business and Collaboration Edition
      • WP pack
      • Hosting pack
      • Power pack
      • Language pack
      • See all Extensions
  • For Partners
    • Plesk Contributor Program
    • Plesk Partner Program
    • Affiliate Program
    • Plesk University
  • Help Center
    • Documentation
    • Professional Services
    • Support
    • Contact Us
    • Wiki
    • Forum
  • Plesk 360 login
  • Free Trial
Plesk 360 login
Free Trial

Knowledge Base

A migrated database in Plesk cannot be accessed via phpMyAdmin: Access denied for user

 
cpaneldatabasedatabasesdirectadmindomains

Symptoms

  • Pop-up occurs when a database is accessed via working phpMyAdmin using Domains > example.com > Databases > exampledb > phpMyAdmin link:

    Enter the password to log in as the database user example_user.

  • phpMyAdmin shows one of the following errors on attempts to access the database directly:

    Connection for example_user as defined in your configuration failed


    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)

  • Might be experienced after migration from Cpanel or DirectAdmin

Cause

The expected behavior.
Passwords are encrypted using asymmetrical encryption and cannot be transferred. The password should be recreated in Plesk manually to access phpMyAdmin.

Resolution

Apply one of the solutions below:

Specify the correct password in the pop-up

  1. Log into Plesk

  2. Go to Domains > example.com > Databases > exampledb > phpMyAdmin

  3. Specify the correct password in the pop-up

Specify the new password via Plesk

Warning: In case this database is being used by any application, make sure that the password matches with the one specified during the procedure below.

  1. Log into Plesk
  2. Go to the Domains > example.com > Databases > User Management > example_user
  3. Specify a new password (or click on the Generate button)
  4. Click the OK button
Tweet
Share
Share
Email
0 Shares
Read the full article
Related Posts

WebPros Announces the Promotion of Jesse Asklund to Chief Product Officer

Read More »

Hosting Control Panels of 2024 – The Definitive Guide

Read More »

Exploring Plesk’s Added Value Solutions So Far in 2023

Read More »
Knowledge Base

Unable to import a database dump: Cannot add or update a child row: a foreign key constraint fails

Read More »

Database import or WordPress cloning fails: Access denied; you need (at least one of) the SUPER privilege(s) for this operation

Read More »

A PHP-based website on Plesk server fails to open: Failed to connect to MySQL: Access denied for user ‘jdoe’@’localhost’ (using password: YES)

Read More »

How to manage customers’ databases in Plesk

Read More »

Hosting Wiki

  • Django
  • Encryption
  • Google Cloud CDN
  • MySQL
  • Linux
  • MongoDB
  • SQL
  • Domain
  • DirectAdmin
  • cPanel/WHM
  • Plesk
  • SQL database
  • NoSQL Database
X-twitter Linkedin Youtube Reddit Github
  • Product
  • Login
  • Pricing
  • Editions
  • For Partners
  • Partner Program
  • Contributor Program
  • Affiliate Program
  • Plesk University
  • Company
  • Blog
  • Careers
  • Events
  • About Plesk
  • Our Brand
  • Resources
  • User and Admin guides
  • Help Center
  • Migrate to Plesk
  • Contact Us
  • Hosting Wiki
  • Forum
  • Legal
  • Legal
  • Privacy Policy
  • Imprint

© 2025 WebPros International GmbH

Part of the WebPros®  Family