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

[Gregory Bluvshteyn]

Hey Allon,

Thanks a lot for response. I guess I will have to either wait for new
version of sql bundle or just switch to another client (I am using Oracle
SQLDeveloper I found it to be the closest to textmate)

But just in case this are the data for the query that you've mentioned.

SELECT User, Host FROM mysql.user;

+------------+---------------------------------------+
| User       | Host                                  |
+------------+---------------------------------------+
| greg       | %                                     |
| greg       | 127.0.0.1                             |
| root       | 127.0.0.1                             |
|            | localhost                             |
| greg       | localhost                             |
| jboss      | localhost                             |
| monty      | localhost                             |
| root       | localhost                             |
| greg       | testing                               |
+------------+---------------------------------------+

SELECT * FROM mysql.user where user = 'greg' \G;

                 Host: 127.0.0.1
                 User: greg
             Password: *2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19
          Select_priv: Y
          Insert_priv: Y
          Update_priv: Y
          Delete_priv: Y
          Create_priv: Y
            Drop_priv: Y
          Reload_priv: Y
        Shutdown_priv: Y
         Process_priv: Y
            File_priv: Y
           Grant_priv: Y
      References_priv: Y
           Index_priv: Y
           Alter_priv: Y
         Show_db_priv: Y
           Super_priv: Y
Create_tmp_table_priv: Y
     Lock_tables_priv: Y
         Execute_priv: Y
      Repl_slave_priv: Y
     Repl_client_priv: Y
     Create_view_priv: Y
       Show_view_priv: Y
  Create_routine_priv: Y
   Alter_routine_priv: Y
     Create_user_priv: Y
           Event_priv: Y
         Trigger_priv: Y
             ssl_type:
           ssl_cipher:
          x509_issuer:
         x509_subject:
        max_questions: 0
          max_updates: 0
      max_connections: 0
 max_user_connections: 0
4 rows in set (0.00 sec)



On 11/12/11 4:59 AM, "Allan Odgaard" <mailinglist at textmate.org> wrote:

> On 11 Nov 2011, at 15:53, Gregory Bluvshteyn wrote:
> 
>> 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
> 
> I¹m talking about the content of: SELECT User, Host FROM mysql.user
> 
>> One strange thing is that, If I put in database name, textmate tries to
>> authenticate as if the database is the host name [Š]
> 
> How do you know that?
> 
>> Would be so great to get this thing fixed [Š]
> 
> Goes without saying that if there is a bug, it would be good to get it fixed.
> 
> But so far we have only determined that the bundle is unable to connect to
> your local install of homebrew¹s mysql build, so what exactly should we fix
> here? ;)
> 
> Have you tried to connect to your local install from other apps (other than
> the mysql client command that came with it)? Could you try install mysqld from
> MacPorts or the ³official² mysql.com version?
> 
> 
> _______________________________________________
> textmate mailing list
> textmate at lists.macromates.com
> http://lists.macromates.com/listinfo/textmate