Why Ubuntu 22.04 droplet with wordpress cannot install phpmyadmin?

Followed the instructions, but kept getting to ‘abort’

For some weird reason, the critical user ‘debian-sys-maint’ was not in the mysys.user table.

Once I added it in CREATE USER ‘debian-sys-maint’@‘localhost’ IDENTIFIED BY ‘<password>’; GRANT ALL PRIVILEGES ON . TO ‘debian-sys-maint’@‘localhost’ WITH GRANT OPTION;

with the password shown in /etc/mysql/debian.cnf

I was then able to install phpmyadmin

Submit an answer

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!

Sign In or Sign Up to Answer

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.

Site Moderator
Site Moderator badge
April 22, 2024

Heya, @soulpresence

I will also suggest to either manually install phpMyAdmin or to use a local database client to access the database. The decision can be made based on your needs. If you’re going to make queries in the database or a general usage, I believe both options will server well.

PhpMyAdmin is a web-based tool written in PHP for managing MySQL databases through a browser. It’s suitable for basic tasks and offers convenience and accessibility. MySQL Workbench or other client, on the other hand, is a desktop application provided by Oracle for comprehensive MySQL database development, administration, and management. It’s favored by developers and database administrators for its advanced features and visual tools. Choosing between the two depends on your preferences and the complexity of your tasks.


Bobby Iliev
Site Moderator
Site Moderator badge
April 18, 2024

Hi there,

Happy to hear that you’ve managed to get this working after updating the debian sys user accordingly. And thank you for sharing your solution here with the community.

I personally prefer installing PHPMyAdmin manually rather than via apt as that way you have full control over the installation. Here is a quick guide on how to do that:

Alternatively, rather than running PHPMyAdmin directly on the server itself, what I could suggest instead is using a local MySQL client like WorkBench or TablePlus and connecting your MySQL instance via an SSH tunnel as described here:

Hope that this helps!



Site Moderator
Site Moderator badge
April 18, 2024


Thank you for pointing that out!

Can you please confirm which Droplet with Wordpress you mean, is it

Try DigitalOcean for free

Click below to sign up and get $200 of credit to try our products over 60 days!

Sign up

Featured on Community

Get our biweekly newsletter

Sign up for Infrastructure as a Newsletter.

Hollie's Hub for Good

Working on improving health and education, reducing inequality, and spurring economic growth? We'd like to help.

Become a contributor

Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.

Welcome to the developer cloud

DigitalOcean makes it simple to launch in the cloud and scale up as you grow — whether you're running one virtual machine or ten thousand.

Learn more
DigitalOcean Cloud Control Panel