Error #1045
| User, date | Message |
|---|---|
|
Written by jamsession
3 years ago Category: General 113 posts since Sat, 22 Dec 07 |
Does anyone know what SQL Error #1045 is? - j |
|
Written by ansgar
3 years ago 4023 posts since Fri, 07 Apr 06 |
D:\>WAMP\mysql-5.1.44-win32\bin\perror.exe 1045 Where did you hear or get that code? |
|
Written by jamsession
3 years ago 113 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
3 years ago 4023 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
3 years ago 4023 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
3 years ago 4023 posts since Fri, 07 Apr 06 |
What HeidiSQL version are we talking about btw? |
|
Written by jamsession
3 years ago 113 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
3 years ago 4023 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
3 years ago 113 posts since Sat, 22 Dec 07 |
v. 5.0.0.3272 - j |
|
Written by ansgar
3 years ago 4023 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
3 years ago 113 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
3 years ago 4023 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
3 years ago 455 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
3 years ago 113 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 
|
|
Written by ansgar
3 years ago 4023 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
3 years ago 113 posts since Sat, 22 Dec 07 |
TCP/IP - j |
|
Written by kalvaro
3 years ago 455 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
3 years ago 113 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
3 years ago 455 posts since Thu, 29 Nov 07 |
What's your doubt about SQLyog? |
|
Written by jamsession
3 years ago 113 posts since Sat, 22 Dec 07 |
What is a "SQLyog" and from where do I get it? - j |
|
Written by ansgar
3 years ago 4023 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
3 years ago 113 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
3 years ago 4023 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
3 years ago 113 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
3 years ago 4023 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
3 years ago 113 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
3 years ago 113 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. |