Question

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.

KFSys
Site Moderator
Site Moderator badge
April 18, 2024

Heya,

Thank you for pointing that out!

Can you please confirm which Droplet with Wordpress you mean, is it https://marketplace.digitalocean.com/apps/wordpress?

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:

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

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:

https://www.digitalocean.com/community/tutorials/how-to-connect-to-a-mysql-server-remotely-with-mysql-workbench

Hope that this helps!

Best,

Bobby

alexdo
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.

Regards

Try DigitalOcean for free

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

Sign up

Become a contributor for community

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

DigitalOcean Documentation

Full documentation for every DigitalOcean product.

Resources for startups and SMBs

The Wave has everything you need to know about building a business, from raising funding to marketing your product.

Get our newsletter

Stay up to date by signing up for DigitalOcean’s Infrastructure as a Newsletter.

New accounts only. By submitting your email you agree to our Privacy Policy

The developer cloud

Scale up as you grow — whether you're running one virtual machine or ten thousand.

Get started for free

Sign up and get $200 in credit for your first 60 days with DigitalOcean.*

*This promotional offer applies to new accounts only.