Getting Connected
When you open Sequel Pro, the first screen that you will see is the database connection window. If you don't have access to a MySQL server, perhaps you could try installing MySQL on your Mac.
Frequently Asked Questions
Try manually setting the socket. The socket depends on how you installed MySQL on your computer. See Where are MySQL's Files? for the socket file location of common installations.
I'm having trouble connecting to a MySQL 4 or MySQL 5 database on localhost with a MAMP install.
See Connecting to MAMP or XAMPP.
On the server, configure MySQL by editing /etc/my.cnf and comment or remove skip-networking
from the [mysqld]
section. Then, restart MySQL Server.
Tips for using the connection screen
General Notes
- If you enter a database, it will be selected when the connection to the server is established. Otherwise you can select one of the databases on the server afterwards.
- If you enter no port on a standard/SSH connection, Sequel Pro uses the default port for MySQL, port 3306.
- If you enter no SSH port on a SSH connection, Sequel Pro uses the default port for SSH, port 22.
- In case you already have a SSH key saved on the remote machine, you can leave the SSH password field empty. Sequel Pro will create the SSH tunnel using that key.
- Click "'Add to Favorites"' to save the connection for use next time you open Sequel Pro. Passwords are stored in the Keychain. To re-order favourites click the pencil in the bottom left of the connection window, (or choose Preferences > Favorites from the Sequel Pro menu) then drag the favourites in the list.
- You can connect to multiple databases simultaneously by opening a new window (File > New) or ⌘ + N