Servers & Services > MySQL

The MySQL database server is offered by most providers worldwide. And in order to be able to provide you with an optimal development environment, with which you come as close as possible to the requirements of most providers, MAMP PRO of course also provides this database server.

MAMP PRO - Servers & Services - MySQL

In the upper right corner of this screen you will find information about which version of the MySQL database server is used and which port is used.

Your MAMP PRO MySQL database data is located in “/Library/Application Support/appsolute/MAMP PRO/db/mysql57”.

MAMP PRO MySQL Data

  • Include MySQL server in GroupStart
    Activate this checkbox if you want the MySQL database server to start and stop automatically when the Start/Stop button in the toolbar is clicked.

  • Check health
    Clicking this button checks the status of the MySQL database server and displays the result in a dialog box.

    MAMP PRO - Servers & Services - MySQL - Check health


  • Change password of database user “root”
    The user “root” acts as administrator of your MySQL database server. By default, the password for this user is “root”. You can change the password by clicking on the button “Change Password”. This button is only active when the MySQL database server is not running.

    MAMP PRO - Servers & Services - MySQL - Change password of database user "root"

    • New Password
      Enter your desired new password here.

    • Verify
      Enter your password again here for verification.

    • Cancel
      Clicking on this button cancels the action and the dialog is closed.

    • Change
      By clicking on this button you set the password you specified. This button is only active if the verification is successful.


  • Allow network access to MySQL
    Select this checkbox if you want to access the MySQL database server over the network. Otherwise, you cannot access your MySQL database server over the network, not even from other locally installed programs.

    • only from this Mac
      Only programs installed on this Mac can access MySQL via network functions.

    • from other computers
      MySQL will answer any network request, even from computers on the internet, depending on you network settings.


  • Administer MySQL with
    MAMP PRO comes pre-installed with phpMyAdmin. You will see a direct link to both Sequel Pro and MySQL Workbench on the MySQL tab if you install them. The buttons to start these tools are only active when the MySQL database server is running.

    • phpMyAdmin
      phpMyAdmin is a web-based administrational tool. It allows you to change data and perform administrative duties like creating new databases.

    • Sequel Pro
      Sequel Pro is a native Mac application. It allows you to create and visualise database schemas in addition to administrative duties. More information on how to connect to MySQL using Sequel Pro can be found in our How To section.

      Using Sequel Pro With MAMP PRO

    • MySQL Workbench
      MySQL Workbench is also a native Mac application from the makers of MySQL. It allows you to visually create database schemas in addition to administrative duties.


  • Path to MySQL log file
    The path to your MySQL log file. This log file is located at “/Applications/MAMP PRO/logs/mysql_error.log”.