This page describes how to connect to the MySQL Server of MAMP or XAMPP running on the same computer as Sequel Pro. If you want to connect to MAMP/XAMPP running on a different computer, please see Connecting to a MySQL Server on a Remote Host.

Contents 1 MAMP 1.1 Connect to MAMP via a unix socket 1.2 Connect to MAMP via a standard TCP/IP connection 2 XAMPP 2.1 Connect to XAMPP via a unix socket 2.2 Connect to XAMPP via a standard TCP/IP connection

MAMP

Connect to MAMP via a unix socket

This is the recommended way of connecting to MAMP.

In the Sequel Pro connection dialog, choose a socket connection.

Enter /Applications/MAMP/tmp/mysql/mysql.sock in the socket field. Type root into the username field. The default password is also root. Optionally enter a name for the connection.

Make sure that MAMP is running and click connect.

Connect to MAMP via a standard TCP/IP connection

You can also connect via a TCP/IP connection.

Enter 127.0.0.1 for the Host. Enter root for the username and for the password. The default MySQL port used by MAMP is 8889.

XAMPP

Just like with MAMP, you can also connect to XAMPP via a socket connection or a standard connection. Only the default settings are a little bit different:

Connect to XAMPP via a unix socket

The unix socket for XAMPP is /Applications/XAMPP/xamppfiles/var/mysql/mysql.sock. Use root as username, and leave the password field blank.

Connect to XAMPP via a standard TCP/IP connection

Type 127.0.0.1 into the host field. Since XAMPP uses the standard MySQL port 3306, you can leave the port field blank. The user name is root, the default password is blank.