Please note: If this FAQ s empty you must choose English language from the drop-down-box below. Only English content is available as of now!
Navigation
- FAQ Home
- All categories
- About Webyog support and about this FAQ
- About the SQLyog program

- Connection issues
- Using the GUI
- Managing your MySQL Database Systems

- Database Schema Synchronization
- MySQL DATA synchronization
- Notification Services
- Importing external data
- Backup/Restore
- SQLyog Job Agent (SJA)

- Working with Views, Stored Procedures and Triggers
- Character Set and Localization Issues
- MySQL bugs that affect SQLyog
- Questions on Open Source and Compiling
- Instant Response
- Sitemap
Most popular FAQs 
- I get error 1130 "Host is not allowed to ... (115243 views)
- Error no. 2003: Can't connect... (51999 views)
- Error no. 1251: "Client does not support authentication..." (48048 views)
- Error no. 1045: "Connection denied..." (41281 views)
- SQLyog Version History (39868 views)
- What is HTTP-tunneling? (29229 views)
- Error No. 2005: Unknown MySQL server host... (28272 views)
- What Is SSH and SSH-tunneling? (25451 views)
- Why are Stored Procedures not created when I import ... (23412 views)
- Do I need PHP to use SQLyog with MySQL? ... (21484 views)
Latest FAQs 
- SQLyog Version History (2010-03-09 03:20)
- SQLyog is a client for the MySQL server - ... (2009-09-11 07:48)
- Can I use SQLyog with the various SQL-modes available ... (2009-08-20 08:02)
- Failed dependency for libstdc++.so.5 error (2009-08-13 11:22)
- Wrong results are returned for FOUND_ROWS(). (2009-08-12 06:31)
Connection issues » Connection problems
Error no. 1045: "Connection denied..."
The error message
Error No. 1045: Connection denied for 'someuser@somehost' (using password: YES/NO)
is a user authentication error. The user details specified do not "match" the user tables of the specified MySQL server. Common situations are
* No such user.
NOTE: MySQL does not use the OS's or domain's user's management. It
operates its own user accounts. With a fresh MySQL installation the
user ROOT is created with NO PASSWORD. When working with MySQL
databases at ISP's an admin user most often must be activated from some
web based Control Panel Application before connection to the MySQL
server is possible. There could be more "rules" applying here (database
and user naming conventions etc). Refer to the docs/support at the ISP for
details on that. We can't give them!
* User is not allowed to connect from the actual host. Note that MySQL by default only allows connection from 'localhost'. To specify from where a user may connect SQL wildcards (% and _) can be used. Simply 'someuser@%' means that user 'someuser' may connect from everywhere.
* Wrong password, missing password or password specified where it should not
* If you are upgrading MySQL from an old version (4.0.x or lower) to a more recent (4.1.x or highere) and if you are still using a rather old PHP version you may need to execute this command from command-line client
SET PASSWORD FOR some_user@localhost = OLD_PASSWORD('newpwd');
(where some_user@localhost is the user used for this connection) since the format for storing passwords has changed between 4.0.x and 4.1.x versions.
Tags: -
Related entries:
- Installation and upgrading
- Buying and Licensing SQLyog
- SQLyog Version History
- Error messages
- Error No. 2005: Unknown MySQL server host...
Last update: 2005-09-20 23:47
Author: Peter Laursen
Revision: 1.0
You can comment this FAQ
Comment of John:
This is nice information however the key that I see missing from most posts is that you don't give me the "how to" part of it.
I still have no idea where to go or what SQL to type to grant the permissions.
You are kind enough to take the time to write all this information, I would suggest taking a few minutes more to type out the syntax of how the grant of permissions should be entered.
Added at: 2008-08-25 18:45
Comment of Peter Laursen:
This is the SQLyog FAQ. SQLyog users will use the SQLyog GUI user management functionalities. The situations where commmand line GRANT syntax are required are 1) After server install on a remote host user may want to grant root access from remote machine 2) When creating an SSL-user
Added at: 2008-09-03 12:56