Access denied for user ‘root’@’localhost’ (using password: YES) after resetting root password

I am getting this when trying to load a webpage that requires the mysql database. I had to go and recently reset the root password that was used for phpmyadmin.

oops connection problem ! --> Access denied for user 'root'@'localhost' (using password: YES)

All this is also running on my Raspberry Pi 2.

I used the below command after these issues which only reset the root phpmyadmin password

sudo dpkg-reconfigure mysql-server-5.5

I can also log in to mysql by using

mysql -u root -p

Answer

I think you need to change the password in the configs of the webpage.

Please check your db credentials in the php page.

Remember:

If you include something that contains the db credentials you should change it there.