Why Ubuntu 22.04 droplet with wordpress cannot install phpmyadmin?

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?

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

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