How do I connect to MySQL with Sequel Ace?

Sequel Ace (previously Sequel Pro) is a macOS application for administering MySQL databases. It can be launched directly from MAMP PRO.

Set up MAMP PRO

1. Install Sequel Ace from the Mac App Store.

2. Start MAMP PRO.

3. Click on MySQL in the sidebar.

4. Enable Allow network access to MySQL.

5. Save the settings with ⌘ S or File › Save.

6. Start the servers.

7. Open Sequel Ace via Tools › MySQL › Open Sequel Ace…, or via Site › Databases › Open in Sequel Ace.

8. Save the connection as a favorite so you can reconnect without re-entering the details each time.

Connect with Sequel Ace

1. Start Sequel Ace.

2. Select the connection type TCP/IP.

   Note

   A socket connection is not available in the App Store version due to Apple’s sandbox restrictions.

3. Enter the following connection details:

   

   Field	Value
   Name	Any name, e.g. MAMP PRO. If you name the favourite “MAMP PRO”, its port will be updated automatically when MAMP PRO changes the MySQL port.
   Host	localhost
   Username	root (default)
   Password	root (default)

4. Click Connect.

You can now use the Choose Database field to select a database.

---

← MySQL how-to guides