Geeks With Blogs
Sathya Narayanan Srinivasan .NET Developer

Here is the solution for the error:
mysqli_connect(): (HY000/1045): Access denied for user (using password: YES)


Make sure that your password doesn't have special characters and just keep a plain password (for ex: 12345), it will work. This is the strangest thing that I have ever seen. I spent about 2 hours to figure this out.

Note: 12345 mentioned below is your plain password that you would like to set for the below username.

GRANT ALL PRIVILEGES ON dbname.* TO 'yourusername'@'%' IDENTIFIED BY '12345';
FLUSH Privileges;
Posted on Sunday, July 16, 2017 3:58 PM mysql , mysql HY000/1045 1045 , HY000/1045 , 1045 , Access denied | Back to top

Comments on this post: mysqli_connect(): (HY000/1045): Access denied for user (using password: YES)

# Nice post
Requesting Gravatar...
This article is interesting as it gives information to the aspirants. Thanks to the author for sharing such a nice blog with us. - japanese classes in chennai
Left by Communiqua on Jul 18, 2017 10:37 AM

# Nice post
Requesting Gravatar...
Hey, this is really a wonderful post. This article is useful for everyone. Thanks for sharing this useful information with us. - high pressure pump, high pressure pumps
Left by Dencil Pumps on Jul 20, 2017 10:52 AM

# september 2017
Requesting Gravatar...

[url=]Employee Attendance Tracker[/url]
Left by anuj on Aug 16, 2017 12:21 PM

Your comment:
 (will show your gravatar)

Copyright © sathya | Powered by: