How do I install phpMyAdmin on Wordpress One-Click deploy droplet (Ubuntu)

I’m trying to setup phpMyAdmin on my WordPress droplet that was setup with the standard One-Click deploy so that I can have greater control over the content.

I’ve followed the guide here but I am stuck on the actual installation of phpMyAdmin when it comes time to enter the database administrator password.

**ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: YES) **

The issue being, the system doesn’t appear to HAVE a password for root. I am able to login to mysql with the following:

$ mysql -u root

Which to me indicates that there is no password. SO what do I enter during this setup process? It seems such a basic and silly thing to be stuck on, so I’d appreciate any help you can offer!



Submit an 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.

Thanks for your help. I was close to this answer but the exact commands to execute to complete this step eluded me, being that I’m not a commandline expert! Your link was helpful but I ended up using this simpler command on a fresh droplet:

$ mysqladmin -u root password NEWPASSWORDHERE

After this the installation proceeded without a hitch.

For the sake of any other users who are also having issues with this process, the outcome of this is three users with access to phpMyAdmin:

  1. root - with password you set with the above command. Access to all DBs incl phpmyadmin and wordpress
  2. phpmyadmin - with password set during phpMyAdmin installation. Seems to only have access to the phpMyAdmin DB
  3. wordpress - with password found in wp-config.php setup as part of the One-Click install script. Access only to the WP DB

Thanks again for steering me in the right direction!

If you wish to use the root MySQL user with PHPMyAdmin you will need to set a password for that user. The Wordpress One-Click uses a different user account for Wordpress itself and you could choose to connect using this already configured user to access your WP database. This information should be found in your wp-config.php in your Wordpress installation directory.