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

Error #1045

User, date Message
Written by jamsession
4 years ago
Category: General
118 posts since Sat, 22 Dec 07
Does anyone know what SQL Error #1045 is?

- j
Written by ansgar
4 years ago
4801 posts since Fri, 07 Apr 06

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

Illegal error code: 1045



Where did you hear or get that code?
Written by jamsession
4 years ago
118 posts since Sat, 22 Dec 07
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
Written by ansgar
4 years ago
4801 posts since Fri, 07 Apr 06
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?
Written by ansgar
4 years ago
4801 posts since Fri, 07 Apr 06
Do you get into HeidiSQL at all then or is that message the last to see and then HeidiSQL dies?
Written by ansgar
4 years ago
4801 posts since Fri, 07 Apr 06
What HeidiSQL version are we talking about btw?
Written by jamsession
4 years ago
118 posts since Sat, 22 Dec 07
* 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
Written by ansgar
4 years ago
4801 posts since Fri, 07 Apr 06
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.
Written by jamsession
4 years ago
118 posts since Sat, 22 Dec 07
v. 5.0.0.3272

- j
Written by ansgar
4 years ago
4801 posts since Fri, 07 Apr 06
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
Written by jamsession
4 years ago
118 posts since Sat, 22 Dec 07
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
Written by ansgar
4 years ago
4801 posts since Fri, 07 Apr 06
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.
Written by kalvaro
4 years ago
564 posts since Thu, 29 Nov 07
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.
Written by jamsession
4 years ago
118 posts since Sat, 22 Dec 07
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
Written by ansgar
4 years ago
4801 posts since Fri, 07 Apr 06

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"?
Written by jamsession
4 years ago
118 posts since Sat, 22 Dec 07
TCP/IP

- j
Written by kalvaro
4 years ago
564 posts since Thu, 29 Nov 07
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
Written by jamsession
4 years ago
118 posts since Sat, 22 Dec 07
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
Written by kalvaro
4 years ago
564 posts since Thu, 29 Nov 07
What's your doubt about SQLyog?
Written by jamsession
4 years ago
118 posts since Sat, 22 Dec 07
What is a "SQLyog" and from where do I get it?

- j
Written by ansgar
4 years ago
4801 posts since Fri, 07 Apr 06
... from the above link which you commented with I don't know what to do with ?
Written by jamsession
4 years ago
118 posts since Sat, 22 Dec 07
When I visited the list, there was a lot listed and, so, I was not sure what to do, from there.

- j
Written by ansgar
4 years ago
4801 posts since Fri, 07 Apr 06
I'd say go for this one: http://code.google.com/p/sqlyog/downloads/detail?name=SQLyog84Community.exe
Written by jamsession
4 years ago
118 posts since Sat, 22 Dec 07
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
Written by ansgar
4 years ago
4801 posts since Fri, 07 Apr 06
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.
Written by jamsession
4 years ago
118 posts since Sat, 22 Dec 07
You might be right, although I don't recall changing either one.

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

- j
Written by jamsession
4 years ago
118 posts since Sat, 22 Dec 07
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.