Question
How do I install phpMyAdmin on Wordpress One-Click deploy droplet (Ubuntu)
- Posted March 17, 2015
- MySQLDigitalOcean 1-Click Apps MarketplaceWordPressUbuntu
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.
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:
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.