I’m trying to follow these instructions to install phpMyAdmin: https://www.digitalocean.com/community/tutorials/how-to-install-and-secure-phpmyadmin-on-ubuntu-18-04

But I get this error after trying to install phpMyAdmin using this command (second step from above):

sudo apt install phpmyadmin php-mbstring php-gettext

This is the error I get:

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

Any one know how to fix this? I have tried a few things that came up in Google, but no luck so far.

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 there @neddytek,

I tried following the article as described and it seems like it works as expected.

Note that you need to also follow the mentioned prerequisites otherwise you might hit unexpected errors.

In my case I had to do the following:

I think that you would get the error in case that you have not run the sudo mysql_secure_installation command from the How to install LAMP tutorial.

Hope that this helps!

by Justin Ellingwood
When you first create a new Ubuntu 18.04 server, there are a few configuration steps that you should take early on as part of the basic setup. This will increase the security and usability of your server and will give you a solid foundation for subsequent...
  • Hi, I actually didn’t install the LAMP server as that is already done in the Marketplace Droplet supplied by Digitalocean for Wordpress. Maybe it’s an issue with the image for Wordpress that is in the marketplace.

    I have previously used the above instructions to setup phpMyAdmin with a fresh Wordpress Droplet, so maybe something has changes in the latest image. I have also submitted a ticket, so maybe they will be able to help and also resolve the issue in the image if there is one.

    In any case, I think I will try to run the command you mention above as it may help.