MAMP and SQLEditor


MAMP is an encapsulated local web server system that allows you to run a complete Web server with PHP and MySQL from a single application on your Mac. It's really easy to install, use and uninstall.

SQLEditor works great with MAMP's MySQL installation, but because MAMP is designed not to affect the existing system it uses a non-standard port to run the MySQL server on.

MAMP normally sets MySQL so that it runs on the non-standard port 8889.

SQLEditor doesn't know this, so you will need to specifically set this in the import and export panels.

How to configure MySQL Support with MAMP

You should configure SQLEditor as normal to use MySQL.
If you need assistance doing this please see the Database Drivers Page.

Enter localhost as the server, with the password and username as necessary.

Then enter 8889 into the port field.


This example should import the database named test, with username root and password root from a MAMP installation on the same machine (localhost)

diagram showing that port number box is on the left side of the fourth row of controls

Mamp Pro

Mamp Pro has an additional configuration option called "Allow local Access Only". If enabled, this option prevents applications running outside of MAMP from accessing the MySQL database.

You need to disable this option before SQLEditor can access the MAMP database.

diagram showing option is in the center of the Server pane of the MAMP pro window

Where can I find out more about this?

The MAMP website has a help page which gives more information.

Support Updates

Contact Us

To contact us with a support issue please email: