I have a problem with a mysql server, whenever i try to connect to it remotely, say with:
mysql -h hostname -u user -p
I enter my password, but then mysql just sits there, no error message, no nothing. Just one new emply line after i typed in my password. What could be the cause of this? It started today. The only change i did was to add a few more users and databases..
Connecting locally, without the -h switch works fine.
most recent debian unstable build, 4.1.11 i think it is.
I didn't touch the install though, at least not for a few weeks..
setting up a proper reverse zone seems to have solved the problem, at least as far as a very quick test can tell. I dont know why it stopped working right now though, maybe its the dns-server and not really the mysql-server, who knows. Me, that is, after i'm done with some more testing