Servers and Services > MySQL

The MySQL database server is a popular database used on production servers. An installation of MySQL is installed on your computer by MAMP PRO. Your MAMP PRO MySQL database data is located in /Library/Application Support/appsolute/MAMP PRO/db/mysql56.

MAMP PRO MySQL Data

MAMP

  • Include MySQL server in GroupStart
    Check to include the MySQL Server in the GroupStart. When activated MySQL server will automatically start/stop when the Servers button is pressed.

  • Version
    The current MySQL version.

  • Data directory
    Displays the location of your MySQL Data. This location cannot be changed.


  • Change password of user “root”
    The Head Database Administrator is called root. This user has unlimited access to all databases. Therefore you should set the password to one only you know.


  • 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 programs installed on this Mac can access MySQL via network functions.

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

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


  • 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.

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

    • 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

    • MySQLWorkbench 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
    Errors occurring at startup or during execution of the MySQL server will be saved in this log file.