Error in installing PHPmyadmin

Posted on May 28, 2020

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.

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

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.

KFSys

May 28, 2020

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

alexdo

May 28, 2020

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