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

# september 2017
Requesting Gravatar...

[url=http://printablecalendarpro.com/attendance-printable-calendar-template/]Employee Attendance Tracker[/url]
Left by anuj on Aug 16, 2017 12:21 PM

# re: mysqli_connect(): (HY000/1045): Access denied for user (using password: YES)
Requesting Gravatar...
I like to play this play fireboy and watergirl online free game and that is for free and online.Click on the link address and able to play and share even without paying or register for the game.
Left by Max994 on Oct 11, 2017 4:03 PM

Your comment:
 (will show your gravatar)


Copyright © sathya | Powered by: GeeksWithBlogs.net