Does MySQL included with MAMP not include a config file?

mysql mamp
Darryl Hein picture Darryl Hein · Mar 24, 2009 · Viewed 68.8k times · Source

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?

Answer

Dirk Einecke picture Dirk Einecke · May 19, 2010

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

Related questions

PHP Warning: mysqli_connect(): (HY000/2002): Connection refused

I am using PHP 5.5 and MAMP (downloaded from here): I have a basic script like this: <?php $servername = "127.0.0.1"; $username = "root"; $password = "root"; // Create connection $conn = mysqli_connect($servername, $username, $password); // Check connection if (!$conn) { die("Connection failed: " . mysqli_connect_…

Read More
MAMP mysql server won't start. No mysql processes are running

My MAMP mysql server won't start. All of the suggestions I've seen on the web say to check for other mysqld processes running and kill them if they exist, and that it should fix the problem, but it has not …

Read More
CakePHP Database connection "Mysql" is missing, or could not be created

There have been several other posts about this, but none of the answers seemed to work for me. When I navigate to the CakePHP page on my local machine, there is one error: Cake is NOT able to connect to …

Read More