Does MySQL included with MAMP not include a config file?

by

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

More Related Contents:

  1. Restoring deleted ‘root’ user and password for MySQL
  2. Error #2002 Can’t connect to local MySQL server through socket ‘/Applications/MAMP/tmp/mysql/mysql.sock’ (2)
  3. NOT LIKE not working with SHOW [duplicate]
  4. MySQL Error 1093 – Can’t specify target table for update in FROM clause
  5. How to define a custom ORDER BY order in mySQL
  6. MySQL update table based on another tables value
  7. Comparison of full text search engine – Lucene, Sphinx, Postgresql, MySQL? [closed]
  8. How to get the number of days of difference between two dates on MySQL?
  9. MySQL Error 1153 – Got a packet bigger than ‘max_allowed_packet’ bytes
  10. conditional join in mysql
  11. a count for each join – optimisation
  12. How to grant all privileges to root user in MySQL 8.0
  13. MySQL Group by SUM
  14. Search for all occurrences of a string in a mysql database [duplicate]
  15. MySQL Aggregate Functions without GROUP BY clause
  16. Count days between two dates, excluding weekends (MySQL only)
  17. How to insert values in table with foreign key using MySQL?
  18. Difference in minutes from two time fields in MySQL
  19. Is there a way to “limit” the result with ELOQUENT ORM of Laravel?
  20. Fixing “Lock wait timeout exceeded; try restarting transaction” for a ‘stuck” Mysql table?
  21. rails + MySQL on OSX: Library not loaded: libmysqlclient.18.dylib
  22. Access mysql remote database from command line
  23. the MySQL service on local computer started and then stopped
  24. NodeJS responded MySQL timezone is different when I fetch directly from MySQL
  25. ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ [duplicate]
  26. How to swap values of two rows in MySQL without violating unique constraint?
  27. SQL date format convert? [dd.mm.yy to YYYY-MM-DD]
  28. Storing images in MySQL [closed]
  29. Would it help to add index to BIGINT column in MySQL?
  30. Are there any functions in MySQL like dense_rank() and row_number() like Oracle?

Leave a Comment