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.
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!
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:
- root - with password you set with the above command. Access to all DBs incl phpmyadmin and wordpress
- phpmyadmin - with password set during phpMyAdmin installation. Seems to only have access to the phpMyAdmin DB
- 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!
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and SMBs
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.