How do I connect to MySQL with Sequel Pro?

Sequel Pro is a macOS application that helps you to administer MySQL databases. Sequel Pro can be started directly from MAMP PRO. Proceed as follows:

  1. Install Sequel Pro. (You can download it here.)
  2. Start MAMP PRO.
  3. Start the servers.
  4. Click on the entry “MySQL” in the sidebar.
  5. Now click on “Sequel Pro” in the “Administer MySQL with” area.
    MAMP PRO - MySQL - Sequel Pro

Of course you can also start Sequel Pro directly at any time.

To establish a connection to the MySQL server of MAMP PRO proceed as follows:

  1. Start Sequel Pro.
  2. Select the connection type “Socket”.
  3. Enter the following connection details:

    Sequel Pro - Connect - Socket

    • Name
      This is the host name. The default host is “localhost”.

    • User name
      This is your MySQL user name. Your MySQL user name will be “root” if you have not changed the default user name setup in MAMP PRO.

    • Password
      This is your MySQL password. Your MySQL password will be “root” if you have not changed the default password setup in MAMP PRO.

  4. Click on the Connect button.

Now you can use the “Choose Database” field in the upper left corner to select the desired database, and so on.

Sequel Pro - Choose Database

Sequel Pro - Database selected