{"action":"created","issue":{"url":"https://api.github.com/repos/sequelpro/sequelpro/issues/2346","labels_url":"https://api.github.com/repos/sequelpro/sequelpro/issues/2346/labels{/name}","comments_url":"https://api.github.com/repos/sequelpro/sequelpro/issues/2346/comments","events_url":"https://api.github.com/repos/sequelpro/sequelpro/issues/2346/events","html_url":"https://github.com/sequelpro/sequelpro/issues/2346","id":120338379,"number":2346,"title":"Using localhost with an SSH tunnel ","user":{"login":"steverobbins","id":3498562,"avatar_url":"https://avatars.githubusercontent.com/u/3498562?v=3","gravatar_id":"","url":"https://api.github.com/users/steverobbins","html_url":"https://github.com/steverobbins","followers_url":"https://api.github.com/users/steverobbins/followers","following_url":"https://api.github.com/users/steverobbins/following{/other_user}","gists_url":"https://api.github.com/users/steverobbins/gists{/gist_id}","starred_url":"https://api.github.com/users/steverobbins/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/steverobbins/subscriptions","organizations_url":"https://api.github.com/users/steverobbins/orgs","repos_url":"https://api.github.com/users/steverobbins/repos","events_url":"https://api.github.com/users/steverobbins/events{/privacy}","received_events_url":"https://api.github.com/users/steverobbins/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/sequelpro/sequelpro/labels/Duplicate","name":"Duplicate","color":"ededed"}],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-12-04T05:55:39Z","updated_at":"2015-12-04T08:29:07Z","closed_at":"2015-12-04T08:24:55Z","body":"I realize that this has been [asked many times before](https://code.google.com/p/sequel-pro/issues/detail?id=1146) but that was 4 years ago and I wanted to see if this could be revisited.\r\n\r\nTo recap, the MySQL grants only allow connection via `localhost`, i.e.\r\n\r\n```\r\nGRANT USAGE ON *.* TO 'user'@'localhost' IDENTIFIED BY PASSWORD <secret>\r\n```\r\n\r\nWhen trying to configure an SSH tunnel using `localhost` as the MySQL host, you are given this message\r\n\r\n![image](http://i.imgur.com/zMGvelB.png)\r\n\r\nBecause this is a shared host and I can't change the grant options, using `127.0.0.1` will not work.\r\n\r\nBased on the response in that mentioned issue, using `localhost` isn't possible \"without additional tools.\"  Are we still facing the same limitation today?  Is there a solution out there now that we can use?"},"comment":{"url":"https://api.github.com/repos/sequelpro/sequelpro/issues/comments/161907666","html_url":"https://github.com/sequelpro/sequelpro/issues/2346#issuecomment-161907666","issue_url":"https://api.github.com/repos/sequelpro/sequelpro/issues/2346","id":161907666,"user":{"login":"dmoagx","id":5793864,"avatar_url":"https://avatars.githubusercontent.com/u/5793864?v=3","gravatar_id":"","url":"https://api.github.com/users/dmoagx","html_url":"https://github.com/dmoagx","followers_url":"https://api.github.com/users/dmoagx/followers","following_url":"https://api.github.com/users/dmoagx/following{/other_user}","gists_url":"https://api.github.com/users/dmoagx/gists{/gist_id}","starred_url":"https://api.github.com/users/dmoagx/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dmoagx/subscriptions","organizations_url":"https://api.github.com/users/dmoagx/orgs","repos_url":"https://api.github.com/users/dmoagx/repos","events_url":"https://api.github.com/users/dmoagx/events{/privacy}","received_events_url":"https://api.github.com/users/dmoagx/received_events","type":"User","site_admin":false},"created_at":"2015-12-04T08:29:07Z","updated_at":"2015-12-04T08:29:07Z","body":"You can however manually create the SSH tunnel with socket forwarding and just connect to the forwarded socket in Sequel Pro for the time being."}}