MAMP PRO (macOS) Documentation

product overview

Search

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 status
    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 status

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

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

    • New Password
      Enter a new password here.

    • Verify.
      Re-enter your password here for verification.

    • Cancel
      Clicking this button will cancel the action and close the dialog.

    • Modify
      Click this button to change the password. This button is active only after successful verification.

  • Allow network access to MySQL
    If you activate this option you can connect to MySQL via IP address (127.0.0.1) and port (for example 8889 or 3306).

    • Only from this Mac.
      Only applications installed on this Mac can access MySQL over the network.

    • From other computers
      See the “Network” panel (System Settings) to find the “IP Address” of the Mac running MAMP PRO.

      macOS - System Settings - Network - Wi-Fi - Details - IP address

  • Administer MySQL with
    MAMP PRO comes with phpMyAdmin preinstalled. You will see a direct link to both Sequel Pro and MySQL Workbench on the MySQL tab when 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 administration tool written in PHP. It allows you to modify data and perform administrative tasks such as creating new databases. MAMP PRO includes two versions of phpMyAdmin to support the different versions of PHP. The dynamic selection of the phpMyAdmin version is based on the PHP version set on the “localhost” host.

      The source files for these instances of phpMyAdmin can be found in “/Library/Application Support/appsolute/MAMP PRO/phpMyAdmin” and “/Library/Application Support/appsolute/MAMP PRO/phpMyAdmin5”. Additional MySQL users can be created using the User Accounts tab.

    • Sequel Ace
      Sequel Ace (previously 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 Ace can be found in our FAQ 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”.

By right-clicking on the “MySQL” entry in the sidebar, various options are available in the contextual menu.

  • Add to GroupStart / Remove from GroupStart
    This option allows you to add or remove the MySQL database server from the GroupStart. If the MySQL database server is added to the GroupStart, then it will be automatically started and stopped when you click the Start/Stop button in the toolbar.

  • If MySQL is running

    • Restart server
      This option allows you to restart the MySQL database server individually.

    • Show my.cnf…
      This option displays the MySQL configuration file (my.cnf) connections currently used by the running server instances. It is displayed read-only. If you want to make changes, you must edit the template.

  • If MySQL is not running

    • Force quit server
      f MySQL is running but MAMP PRO is unable to detect the correct status, the application may not be able to (re)start or stop the server instances. Calling this function will help MAMP PRO regain control of MySQL.