[TxMt] Re: SQL.Bundle -> Bad Handshake Issue -> Mac OSX Lion

[Gregory Bluvshteyn]

HI Allan,

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 at 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" <mailinglist at textmate.org> 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
> textmate at lists.macromates.com
> http://lists.macromates.com/listinfo/textmate