As I was following this tutorial (https://www.digitalocean.com/community/tutorials/how-to-install-and-secure-phpmyadmin-on-ubuntu-16-04), I encountered this error upon installation:
“Access is denied for user ‘debian-sys-maint’@'localhost’”

Our droplet is on Ubuntu 18.04 and I have already installed MySQL.

Can you help me with this problem? Thanks.

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.

×
2 answers

Hello, @marketingadmin

This questions was previously asked in our community and was answered by @bobbyiliev

You can check the original question here: https://www.digitalocean.com/community/questions/can-t-install-phpmyadmin-on-fresh-wordpress-droplet

“I’ve tried recreating the error at my end as well, it looks like that the debian-sys-maint MySQL user is missing and the phpMyAdmin installation is looking for it.

What I could suggest here is:

  • Either try to create that user so that the apt install phpMyAdmin installation could go through as normal.

  • Or install phpMyAdmin manually rather than using the package from the apt repo.

I’ve put together a mini-tutorial on how to do that manually:

https://www.digitalocean.com/community/questions/how-to-install-manually-phpmyadmin-on-ubuntu

Hope that this helps!

Regards,
Alex

Hi @marketingadmin,

How are you experiencing this problem? Are you trying to enter into your MySQL instance or your website is not loading?

I would assume after you’ve followed the tutorial above, you’ve either changed your password somehow or you’ve added a security layer that now requires a password to be given.

It really depends on the command you are using so, can you please let me know how are you getting to this error and I’ll be able to provide you with more information about it.

Regards,
KDSys

Submit an Answer