Location of my.cnf file on macOS

by

This thread on the MySQL forum says:

By default, the OS X installation does not use a my.cnf, and MySQL just uses the default values. To set up your own my.cnf, you could just create a file straight in /etc.

OS X provides example configuration files at /usr/local/mysql/support-files/.

And if you can’t find them there, MySQLWorkbench can create them for you by:

  1. Opening a connection
  2. Selecting the ‘Options File’ under ‘INSTANCE’ in the menu.
  3. MySQLWorkbench will search for my.cnf and if it can’t find it, it’ll create it for you

More Related Contents:

  1. Reorder / reset auto increment primary key
  2. Implementing Comments and Likes in database
  3. How to check if mysql database exists
  4. difference between primary key and unique key
  5. How to shrink/purge ibdata1 file in MySQL
  6. Error creating table: You have an error in your SQL syntax near ‘order( order_id INT UNSIGNED NOT NULL AUTO_INCREMENT, user_id ‘ at line 1 [duplicate]
  7. Difference Between Schema / Database in MySQL
  8. How do I add a custom CHECK constraint on a MySQL table?
  9. Error: Tablespace for table xxx exists. Please DISCARD the tablespace before IMPORT
  10. DOs and DONTs for Indexes [closed]
  11. MySQL triggers cannot update rows in same table the trigger is assigned to. Suggested workaround?
  12. Implementing a hierarchical data structure in a database
  13. Does MySQL allows to create database with dot?
  14. Commit data in a mysql container
  15. Laravel join with 3 Tables
  16. Difference between two table structure
  17. rails + MySQL on OSX: Library not loaded: libmysqlclient.18.dylib
  18. When to use MyISAM and InnoDB? [duplicate]
  19. How to insert a file in MySQL database?
  20. Why doesn’t MySQL’s MyISAM engine support Foreign keys?
  21. MySQL equivalent of Oracle’s SEQUENCE.NEXTVAL
  22. Foreign key to one of many tables?
  23. What’s the recommended way to connect to MySQL from Go? [closed]
  24. Where does MySQL store database files on Windows and what are the names of the files?
  25. How to find all the relations between all mysql tables?
  26. Should I normalize my DB or not?
  27. How to speed up sql queries ? Indexes?
  28. MySQL: how to do row-level security (like Oracle’s Virtual Private Database)?
  29. Inventory management with stock options
  30. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)

Leave a Comment