Can I change the location of the files of MySQL databases?

No, you cannot change the location of the files of MySQL databases.

What data is in my "/Library/Application Support/appsolute/MAMP PRO/db/mysql56" folder?

This directory contains your pre upgraded MySQL data. When you upgrade from MAMP PRO 4 to MAMP PRO 6 your MySQL is duplicated and named "mysql57". Your old MySQL will never be used, and when you confi...

Where is my my.cnf file located?

The configuration file "my.cnf" of MySQL can be found here: "/Applications/MAMP/tmp/mysql/my.cnf". Please note: Editing this file does NOT work as it will be overwritten every time MySQL is restarted ...

Can I use MySQL 5.6 with MAMP PRO 6?

No, you can not upgrade or downgrade the version of MySQL that comes with MAMP PRO. You must use MySQL 5.7.

How can I change the MySQL password?

Open MAMP PRO Stop the servers if they are already running. Click on the MySQL entry in the left sidebar. Click on the button "Change password". A dialog for enterin

How do I connect to MySQL with Sequel Ace?

Sequel Ace (previously Sequel Pro) is a macOS application that helps you to administer MySQL databases. Sequel Ace can be started directly from MAMP PRO. Proceed as follows: Install Sequel Ace. (You c...

How do I connect to MySQL with PHP?

How do I connect to MySQL with Python?

How do I connect to MySQL with Perl?

How do I determine the default MySQL Storage Engine?

Open MAMP PRO Start the servers Open Terminal.app (/Applications/Utilities) Enter the following line into the terminal and hit enter:cd /Applications/MAMP/Library/bin Enter the following line into the...

How do I define the default MySQL Storage Engine?

The MySQL server of MAMP PRO uses the Default Storage Engine MyISAM. If you want to change this, you have to change the configuration file of the MySQL server. With this tutorial we want to show you h...

How to transfer database data from MAMP to MAMP PRO?

Stop all servers and close MAMP and MAMP PRO. Switch to the Finder, press cmd-shift-G (or select "Go to Folder") and type or paste "/Library/Application Support/appsolute/MAMP PRO/db/" and click "Open...

MySQL will not start

The most common reason for the MySQL database server not starting is that another MySQL database is already running on the same port. To find out if this is the case, do the following: Quit MAMP PRO. ...

What can I do if the MySQL server is slow?

You can diagnose why your MySQL is slow by adding the following to your "my.cnf" template file below [mysqld]. slow-query-log = 1 slow-query-log-file = /applications/mamp/logs/mysql-slow.log long_quer...

MySQL server does not start because of a sequence number

This may occur when your Mac goes to sleep. 10:12:32 1753 [Note] InnoDB: The log sequence numbers 609248312 and 609248312 in ibdata files do not match the log sequence number 609248322 in the ib_logfi...

Change the interface language of phpMyAdmin permanently

To permanently change the interface language of phpMyAdmin to any language you like, proceed as follows: Open the file "/Library/Application Support/appsolute/MAMP PRO/phpMyAdmin/config.inc.php" in a...

Table mysql/innodb_table_stats has length mismatch

If you see the following output in the MySQL log file (mysql_error.log) InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade then you need...

I upgraded to MAMP PRO 6 and I am missing databases

Stop all servers and close MAMP and MAMP PRO. Switch to the Finder, press cmd-shift-G (or select "Go to Folder") and type or paste "/Library/Application Support/appsolute/MAMP PRO/db/" and click "Ope...

Where is my MySQL database data located?

MAMP and MAMP PRO store MySQL database data in different folders. MAMP PRO MAMP PRO 3 stores data in /Library/Application Support/appsolute/MAMP PRO/db/mysql MAMP PRO 4 stores data in /Library/Applic...

Change PHP configuration for phpMyAdmin

If the default PHP configuration values for upload_max_filesize or post_max_size are too low for your needs when using phpMyAdmin, then you can easily change these values via MAMP PRO. To do this, fir...

Use the same values for the database connection locally and remotely

If you use a connection to the MySQL database in PHP applications, the values used for the database connection on the local system with MAMP PRO and the remote server are not identical in most cases. ...