An Exploring South African

Curiosity, Travel, Family, and Discovering New Places

Menu

Skip to content
  • About
  • Explore

SQLyog: Connection Denied for User Error CodeUnit 13 APR 2010

SQLyog is an absolutely brilliant GUI front-end for MySQL databases. Delivering all functionality you could ever want to apply to a database, MySQL makes database administration a breeze and more importantly, a snap.

Have you ever come across the following error dialog when trying to connect to a MySQL database?

Error No. 1045: Connection denied for ‘someuser@somehost’ (using password: YES/NO)

Basically what this is, is a user authentication error. In other words, the user details specified does not “match” the user tables on the specified MySQL server.

Reasons for this could include the user account simply not existing, the wrong password for that particular user, or lastly, the user specified may not actually be able to connect from the host you are currently using.

The last one is the interesting one and usually the most common cause of throwing up the error when trying to use SQLyog to administer an external database.

Typically MySQL only allows connection from ‘localhost’ by default. If you want to allow an user to connect from a different host, you’ll need to edit the privileges for that user on the native machine and specify that the host.

Wildcard characters do of course make our lives much easier and as an example using phpMyAdmin on the MySQL server machine, you can see from the picture below that I’ve changed a user account’s privileges to allow him to connect from any host by using the value of % in the host field.

So make sure you have the right user password and user name, make double sure that your user can access from any host and blam, your connection denied error should soon be a thing of history! :)

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)
  • Click to share on Google+ (Opens in new window)
  • Click to share on Reddit (Opens in new window)
  • Click to share on Pinterest (Opens in new window)

Related

Tuesday 13/04/2010CodeUnitconnection, connection error, error, host, host denied, mysql, privileges, sqlyog, user accountCraig Lotter
Related Posts:

About Craig Lotter

Software developer, husband and dad to two little girls. Writer behind An Exploring South African. I don't have time for myself any more. View all posts by Craig Lotter →

Post navigation

← Cough Splutter Cough Portfolio: EPRU Tree Logo (October 2007) →

Follow An Exploring South African on Instagram: @craiglotter

Ads by Project Wonderful! Your ad could be here, right now.

An Exploring South African

Curiosity, Travel, Family, and Discovering New Places. An Exploring South African is a family travel blog by aspiring travel writer and full-time software developer Craig Lotter.

Craig Lötter

South African software architect and developer at Touchwork. Husband to a wedding cake baker and father to two little girls.

I don't have time for myself any more.

       

Subscribe via Email

Like what you see?

Enter your email address to subscribe to this blog and receive notifications of new content via email.

Join 1,078 other subscribers

Post Categories

Blog Awards

African Blogger Awards 2015 Winner: Personal Category
African Blogger Awards 2015 Winner: Personal Category
Copyright © 2007-2018 Craig Lötter | Rugged Rock Studio | Proudly powered by WordPress