Question

Cannot get phpmyadmin to work

Posted October 10, 2018 3.9k views
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??

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.

×
3 answers

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.

by Mark Drake
phpMyAdmin is an application that allows users to interact with MySQL databases through a web interface. This tutorial covers the process of installing and securing phpMyAdmin on an Ubuntu 18.04 server.

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 .digitaloceanpassword) it give me error mysqlireal_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.
by Mark Drake
phpMyAdmin is an application that allows users to interact with MySQL databases through a web interface. This tutorial covers the process of installing and securing phpMyAdmin on an Ubuntu 18.04 server.
Submit an Answer