Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Does MySQL included with MAMP not include a config file?

Tags:

mysql

mamp

I can't seem to find the my.cnf or other config file for the MySQL that comes with MAMP. Does it not include one?

like image 927
Darryl Hein Avatar asked Mar 24 '09 18:03

Darryl Hein


People also ask

Does MAMP include MySQL?

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

Where is MySQL located in MAMP?

Your MySQL 5.7 database data is located in “/Library/Application Support/appsolute/MAMP PRO/db/mysql57”.


Video Answer


1 Answers

The MySQL server of MAMP (not PRO) will be started without any my.cnf file. But you can create your own my.cnf file.

  1. Stop servers
  2. Create a my.cnf file in /Applications/MAMP/conf/
  3. Add your content in to my.cnf
  4. Save my.cnf
  5. Start servers

You do not have to put a complete configuration in the my.cnf file. You can just add parts of a configuration ... for example:

[mysqld] max_allowed_packet = 64M 
like image 156
Dirk Einecke Avatar answered Sep 18 '22 13:09

Dirk Einecke