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@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@lists.macromates.com http://lists.macromates.com/listinfo/textmate