An Exploring South African

Things to do in Cape Town, the Helderberg, and the Cape Winelands

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 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

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) →

An Exploring South African

Curiosity, travel, and discovering new places. Craig Lotter's An Exploring South African is primarily a South African travel blog of things to do in and around Cape Town, the Helderberg, and the Cape Winelands.

Craig Lötter

A South African software developer at Touchwork, Craig Lotter is a husband to a cake baker, father to two young girls, and someone who is constantly looking for new places to explore. He is also not that bad of a writer either.

   

Instagram

Subscribe via Email

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

Copyright © 2007-2021 Craig Lotter | Rugged Rock Studio | Proudly powered by WordPress