Cannot get phpmyadmin to work

  • Posted October 10, 2018
  • MySQL

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??


Submit an 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 -

But now when i login in to 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.