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

# re: mysqli_connect(): (HY000/1045): Access denied for user (using password: YES)
Requesting Gravatar...
Thanks for the tips you have offered here there has been a lot of queries regarding this topic online. You have done an excellent work with providing examples along with the detail to have a better idea of the topic. Tours of Washington DC
Left by Taylor Shaw on Dec 12, 2017 3:21 PM

# re: mysqli_connect(): (HY000/1045): Access denied for user (using password: YES)
Requesting Gravatar...
Thanks for sharing is an informative article and here lots of queries have shared and that will be it is really helpful for me.This type of article is very useful to me and please add more details.anti snoring mouth guard
Left by ann on Feb 22, 2018 5:48 PM

Your comment:
 (will show your gravatar)


Copyright © sathya | Powered by: GeeksWithBlogs.net