Thanks a lot for you response. No anything connecting to homebrew doesn't work. I was able to get queries going when I've installed ubuntu and ran mysql there.
I tried all of the possible combinations:
Localhost with/without 3306 127.0.0.1 with/without 3306 greg-macbook.local (which is my computer name) with/without 3306
Still to no avail.
One strange thing is that, If I put in database name, textmate tries to authenticate as if the database is the host name from which textmate is connecting. For example, lets say I have a db called my_db so that the textmate tries to authenticate using root@my_db e.t.c
So I am not using database name when I log in.
Would be so great to get this thing fixed. I am sure I am not the only one out there, so It would help so many other people.
On 11/11/11 7:43 AM, "Allan Odgaard" email@example.com wrote:
On 11 Nov 2011, at 00:01, Gregory Bluvshteyn wrote:
 Is there logs related to textmate that I can check for the authentication issues? Mysql error/access logs are empty in that case.
The SQL bundle is echoing the MySQL server error, so more exact info about the issue should be available on the server-side (if any).
I googled your error message and it seems that it (often) has to do with protocol version and/or password hashing.
I see you mentioned to Michael that it actually does work with your homebrew install if you create a mysql user coming from any host, is that correct? If so, what have you used as host limitation when getting the bad handshake error? Have you tried locahost versus 127.0.0.1 versus the actual hostname of your computer, etc.?
textmate mailing list firstname.lastname@example.org http://lists.macromates.com/listinfo/textmate