Error #1045

Does anyone know what SQL Error #1045 is?

- j

D:\>WAMP\mysql-5.1.44-win32\bin\perror.exe 1045
Illegal error code: 1045

Where did you hear or get that code?

I would encounter the error whenever I during the start, of Heidisql.

Here are the steps. [Note: Keep in mind that the ip and password are correct.]

So:

1. I double-clicked on the Heidisql icon.

2. I clicked open.

Then the error message shows up. For example, the message would be something like:

SQL Error (1045): Access denied for user...@...(using password: YES)

My host's tech people said that they could not find a problem.

So, that left me wondering about Heidisql.

- j

Hm, do you get this "Access denied" message along with error code 1045 or what? In that case, the message clearly says what's up - some privilege error, or not?

Do you get into HeidiSQL at all then or is that message the last to see and then HeidiSQL dies?

What HeidiSQL version are we talking about btw?

* Sorry, I got mixed up and posted my responses under the wrong post.

So, here they are, again.



1. 5.? Normally, I update on a daily basis. Heidisql says last connected 12 days ago. So, my version would have been the latest one, at that date.

2. The initial panel, which displays settings, ssl options, and statistics, shows. But the error message appears after I click the open button.

3. No. Only the error message, as shown in my Apr. 24, 2010 post, above, appears. There are no other indications as to what might be up. Further, I am the admin. So, I have all privileges.

To be sure, I just re-set the password and assigned all privileges, again.

But the error message re-appeared.

- j

Please tell me the exact revision of heidisql.exe - it's also displayed in the systems popup menu when you click the upper left icon of the session dialog.

v. 5.0.0.3272

- j

Ok, then there is no relevant change in Heidi regarding your problem.

Probably you have set up an anonymous user account which prevents your normal user from login? See http://forums.mysql.com/read.php?10,9919,208812#msg-208812

I briefly scanned some of the postings, at the site, and noticed that they are dealing with Linux.

Yet, I am using the Windows version of Heidisql.

So, are you implying that my problem is with my host's Linux server and not Heidisql?

- j

There is only HeidiSQL for Windows, no Linux version. Linux users use HeidiSQL via Wine, a Windows emulator for running .exe files, which works good. Other posters refer to Linux as OS for their MySQL server. Very cross OS stuff here, yes, and sometimes confusing :)

are you implying that my problem is with my host's Linux server and not Heidisql?

No, nothing OS specific here. By "anonymous user account" I meant a MySQL user, not some system user in case you mixed that up.

Access denied errors are pretty self-explanatory. However, if you have double-checked your user and password (you have, haven't you?)... are you by chance using a password with some non-ASCII characters on it? Latest HeidiSQL versions seem to have an issue with such chars.

1. I have checked, checked, and re-checked the username & password and, to me, nothing seems wrong.

My host's techs said that the password worked for them.

I have not created any new usernames.

I did not see any new usernames.

Yet, I still get Error #1045 and it says that I am using the correct password.

So,...




2. Password characters?

I just use whatever the server's password generator recommends.

Moreover, I've tried changing this password many times, now, but I still get the error #1045.

So, I'm at a loss.



- j

I still get Error #1045 and it says that I am using the correct password

"using password: YES" does not mean you are using the correct password, man, just that there was a non-empty one passed.

Which "Network type" did you select in Heidi's session manager, is it "TCP/IP" ? Probably you accidentally switched to "Named pipe" or "SSH tunnel"?

TCP/IP

- j

When you say I've tried changing this password many times I presume you are using only numbers and English letters. Well, it was a blind shot :)

It'd be interesting to know if you can connect with other clients. It could help to isolate the issue:

http://www.mysql.com/downloads/workbench/
http://code.google.com/p/sqlyog/downloads/list

I installed workbench, but it keeps crashing during start.

I don't know what to do with http://code.google.com/p/sqlyog/downloads/list .

- j

What's your doubt about SQLyog?

What is a "SQLyog" and from where do I get it?

- j

... from the above link which you commented with I don't know what to do with ?

When I visited the list, there was a lot listed and, so, I was not sure what to do, from there.

- j

I'd say go for this one: http://code.google.com/p/sqlyog/downloads/detail?name=SQLyog84Community.exe

SQLyog said:

Error No. 1045
Access denied for user '...@...' (using password: YES)



HeidiSQL said:

SQL Error (1045): Access denied for user '...@...' (using password: YES)



Perhaps I should just re-install Heidisql?

- j

In what way could it help to install HeidiSQL when even other clients give you the same error? The fact that two clients give you this "access denied" error tells you that your username/password is definitely incorrect. Or the user account is set up to disallow external connections. Please contact your host's admin again. Let him create a new user for you if you feel that nothing else helps.

You might be right, although I don't recall changing either one.

So, I'll look into and get back to you.

- j

Turns out that, somehow, my password got changed.

But things appear to be fixed, now.

I updated to v. 5.1.0.3336.

Everything appears to be working.

I have no idea how the password got changed.

Thanks, however, for the help!

- j