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

March 17, 2015 2.8k views
MySQL One-Click Install Apps WordPress 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!


2 Answers

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.

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!

Have another answer? Share your knowledge.