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??
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.
hİ, update came. try this https://www.digitalocean.com/community/tutorials/how-to-install-and-secure-phpmyadmin-on-ubuntu-18-04
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.