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/mysql57”.
- 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.
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.Note: The default password of root is "root". To make things even more confusing there is also a user root inside Mac OS X. Don't confuse them. You can also use one of the MySQL administration tools to create other MySQL users if you do not want to use root.
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.
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.