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
- 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.
The current MySQL version.
Displays the location of your MySQL Data. This location cannot be changed.The MAMP PRO Uninstaller will delete this directory. Make backups before using the uninstller!
- 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 the checkbox for allow network access to MySQL is not checked, network access to the database is prohibited, even from programs installed locally.Note: This is an advanced feature not needed for local development.
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.
- 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.