Geeks With Blogs

Sathya Narayanan Srinivasan .NET Developer
ERROR 1045: Access denied for user: 'root@localhost' (Using  password: YES) php mysql hosted on a linux server - Solution after struggling for 3 hours

Hey guys,

  I broke my head for about 3 hours to solve this issue :

ERROR 1045: Access denied for user: 'root@localhost' (Using  password: YES)

Tried google so many times with different possible combinations and it didnt work out.

I got the following link in bing, which was the 2nd result and it finally solved the problem.

https://help.ubuntu.com/community/MysqlPasswordReset

Here is the answer : Dont set a complex password. I had something like 12adfssdaf#$  as my password originally, then finally set it to 12asdfas34 and it worked. 

Here are the commands I used in mysql :

FLUSH Privileges;
select * from user; -- this is to identify which user doesnt have password. Set passwords properly for all accounts that doesnt have a password and all accounts that has a complex password with symbols.
SET PASSWORD FOR myusername@'localhost' = PASSWORD('12aasdfdsdf34');
FLUSH Privileges;

Go and refresh your php page, it will work.

Actually I hosted in multiple different providers and had the same issue everywhere. Followed the above steps and resolved the issue everywhere. So trust me, this works!!


Posted on Thursday, April 14, 2016 3:15 PM php , mysql , error , solution | Back to top


Comments on this post: ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) php mysql hosted on a linux server - Solution after struggling for 3 hours

No comments posted yet.
Your comment:
 (will show your gravatar)


Copyright © sathya | Powered by: GeeksWithBlogs.net