Related

Product Now Available: Managed MySQL Databases Product
Run Django Python 2 and Python 3 apps with uWSGI and nginx on same server? Question Question
After updating bind-address in /etc/msql/my.cnf file MySQL stops working Question Question

Question

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

Posted March 17, 2015 6.7k views
UbuntuMySQLWordPressDigitalOcean 1-Click Apps Marketplace

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!

Thanks.

Add a comment
adrian.halliday
By:
adrian.halliday
Add a comment

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.

×
2 answers
ryanpq March 17, 2015

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.

Reply Report
adrian.halliday March 18, 2015

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!

Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help