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 C:\Users\Public\Documents\Appsolute\MAMPPRO\db\. To connect to your MySQL database in MAMP PRO you must use TCP/IP (network) connections.

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.

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

  • Administer MySQL with

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

  • Path to MySQL log file
    Errors occurring at startup or during execution of the MySQL server will be saved in this log file.