Connect Sequel Pro to MySQL in OS X Server
In OS X Server we could never get Sequel Pro connected to MySQL. We were not sure if this was a common issue for most users, or just a problem we were having.
Attempts at "Standard" or "Socket" connection methods were denied, but it turns out "SSH" is the way to go. We wanted to post this in case any other OS X Server users were having the same problem, and the developer site offers no tips for OS X Server.
We are running OS X Server 10.8 Mountain Lion on a MacMini, but this should also resolve the same problem for 10.6-10.7 setups.
1. Make sure that MySQL is running on your server, which there is now a Preference Pane for: http://dev.mysql.com/doc/mysql-macosx-excerpt/5.6/en/macosx-installation-prefpane.html
2. Remote connections to your server must also be enabled.
In OS X Server 10.8, check for this setting under Systems Prefs > Sharing, and verify "Remote Login" is checked. (In 10.6 Snow Leopard SSH might have been a setting in Server.app side tray/services list? Sorry, we cannot remember...)
3. Now create a new connection Favorite in Sequel Pro.
Please note the upper password is for MySQL, the lower SSH password is for your Mac user account. These are the settings we used for our installation:
We hope this helps anybody else who was running into the same Sequel Pro connection problems on OS X Server.