ERROR 1045 (28000): Access denied for user │ 'debian-sys-maint'@'localhost' (using password: YES)

Posted August 17, 2021 823 views
UbuntuMySQLApachePHPUbuntu 20.04

I created a Droplet from the Wordpress Marketplace image. I tried to install PHPMyAdmin. During the installation, the following message appears:

ERROR 1045 (28000): Access denied for user                                 
  │ 'debian-sys-maint'@'localhost' (using password: YES)

I have not been able to find an answer to why this occurs or how to fix it.

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Submit an Answer
1 answer

Hi @howard,

This error is related to your MySQL instance. Basically, whatever you’ve been doing, the user ‘debian-sys-maint’ has tried to access a database using a password but failed.

This can be due to a couple of reasons. The user you are using 'debian-sys-maint’ does not have sufficient privileges to access the database you’ve been trying to access or even though the password is being used, it’s wrong. Alternatively, can be both those things together.

Can you describe the process you’ve been following to install the Database so that I can give you some pointers?

  • So, I started with the Wordpress Droplet from the Marketplace. MySQL was already installed.

    I figured out the problem. PHPMyAdmin wants to use the debian-sys-maint MySQL user to install / administer PHPMyAdmin. I needed to create this user and assign it the password that PHPMyAdmin expected.