Question
Why Ubuntu 22.04 droplet with wordpress cannot install phpmyadmin?
- Posted on April 17, 2024
- Technical DevelopmentMySQLApacheWordPressUbuntu 22.04
Asked by soul presence
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
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.
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.
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
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
aptas 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!
Best,
Bobby
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?