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!
hİ, update came. try this https://www.digitalocean.com/community/tutorials/how-to-install-and-secure-phpmyadmin-on-ubuntu-18-04
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.
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.
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
Full documentation for every DigitalOcean product.
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
Stay up to date by signing up for DigitalOcean’s Infrastructure as a Newsletter.
New accounts only. By submitting your email you agree to our Privacy Policy
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.