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!
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.