Report this

What is the reason for this report?

Cannot get phpmyadmin to work

Posted on October 10, 2018

I am trying to set up a web server. Everything works fine except for the mysql/phpmyadmin, i cannot sign in and i just get " #1045 - Access denied for user ‘root’@‘localhost’ (using password: YES)"

Please help me as i have been trying to figure this out for a couple of hours now,

i have also tried making new droplets and setting up phmyadmin on them and they wont work eithher

what am i doing wrong??



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!

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.

i am also facing this issue.

I have install phpmyadmin by this tutorial - https://www.digitalocean.com/community/tutorials/how-to-install-and-secure-phpmyadmin-on-ubuntu-18-04

But now when i login in to example.com/phpmyadmin with username as root and password found in (cat .digitalocean_password) it give me error mysqli_real_connect(): (HY000/1045): Access denied for user ‘phpmyadmin’@‘localhost’ (using password: YES) and never let me login.

On other hand when i try login with username “wordpress” and password provided in (cat .digitalocean_password) , i am succesfully logged in.

  1. I dont know why it create two username and password (1 is root, 2 is wordpress)
  2. when i open wp.config file, there username is wordpress.
  3. Now i am thinking that username root does not exist but (cat .digitalocean_password) file show password for root.

What password are you using at the login prompt of phpmyadmin? It needs to be MySQL’s root password. Which if it’s the default one, it’s blank. Make sure you change it to a strong password.

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.