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)

Solution:

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

http://www.communiqua.com/japanese-classes-in-chennai.html
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

http://www.dencilpumps.com/products/pumps/high-pressure-pumps.html
Left by Dencil Pumps on Jul 20, 2017 10:52 AM

Your comment:
 (will show your gravatar)


Copyright © sathya | Powered by: GeeksWithBlogs.net