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.
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
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
well, what if my connection outputs are ok, and the mysql database connects with no problems on the first time operating an insert but on the second time, and so on, operating that same insert gives the 1045 error? what does this means?
Added at: 2013-07-12 19:26
It still means the same. It is still a MySQL *SERVER* error. But since this happens this way I think you must be using HTTP tunnel (if you are using SQLyog)? Or it could be a server bug. What is the server version? Anyway .. this is not the best place for supporting you with this. Please use our Forums to ask support or mail to support@webyog.com (but only if you are a SQLyog user) -- Peter Laursen -- Webyog
Added at: 2013-07-12 20:34