Here are the steps. [Note: Keep in mind that the ip and password are correct.]
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.
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.
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
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.
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.
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.
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"?
It'd be interesting to know if you can connect with other clients. It could help to isolate the issue:
I don't know what to do with http://code.google.com/p/sqlyog/downloads/list .
Please login to leave a reply, or register at first.