distal-attribute
distal-attribute
distal-attribute
distal-attribute

Error #1045

jamsession posted 4 years ago in General
Does anyone know what SQL Error #1045 is?

- j
ansgar posted 4 years ago

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

Illegal error code: 1045



Where did you hear or get that code?
jamsession posted 4 years ago
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
ansgar posted 4 years ago
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?
ansgar posted 4 years ago
Do you get into HeidiSQL at all then or is that message the last to see and then HeidiSQL dies?
ansgar posted 4 years ago
What HeidiSQL version are we talking about btw?
jamsession posted 4 years ago
* 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
ansgar posted 4 years ago
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.
jamsession posted 4 years ago
v. 5.0.0.3272

- j
ansgar posted 4 years ago
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
jamsession posted 4 years ago
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
ansgar posted 4 years ago
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 :)

jamsession wrote: 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.
kalvaro posted 4 years ago
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.
jamsession posted 4 years ago
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 unhappy
ansgar posted 4 years ago

jamsession wrote: 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"?
jamsession posted 4 years ago
TCP/IP

- j
kalvaro posted 4 years ago
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
jamsession posted 4 years ago
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
kalvaro posted 4 years ago
What's your doubt about SQLyog?
jamsession posted 4 years ago
What is a "SQLyog" and from where do I get it?

- j
ansgar posted 4 years ago
... from the above link which you commented with I don't know what to do with ?
jamsession posted 4 years ago
When I visited the list, there was a lot listed and, so, I was not sure what to do, from there.

- j
ansgar posted 4 years ago
I'd say go for this one: http://code.google.com/p/sqlyog/downloads/detail?name=SQLyog84Community.exe
jamsession posted 4 years ago
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
ansgar posted 4 years ago
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.
jamsession posted 4 years ago
You might be right, although I don't recall changing either one.

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

- j
jamsession posted 4 years ago
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

Please login to leave a reply, or register at first.