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

  • 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 written in PHP. It allows you to change data and perform administrative duties like creating new databases. MAMP PRO includes two versions of phpMyAdmin to support the different PHP versions. For the dynamic selection of the phpMyAdmin version, the PHP version that is set on the host “localhost” is relevant.

      The source files for these instances of phpMyAdmin are located 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…
      Calling this option will display the MySQL configuration file (my.cnf) connections currently used by the running server instances. It will be displayed read-only. If you want to make changes you have to edit the template.

  • If MySQL is not running

    • Force quit server
      If MySQL is running but MAMP PRO is not able to detect the correct status the application might not be able to (re)start or stop the server instances. Calling this function will help MAMP PRO to get back control of MySQL.