I installed MySQL 5.0 using pkgutil, and I want to change the my.cnf file to adjust settings. Where to find this file?

This question is marked "community wiki".

asked 07 Feb '12, 14:56

automaciej's gravatar image

automaciej ♦♦
93273037
accept rate: 55%


MySQL has default search locations for the my.cnf file. When you enter the following command:
mysql --verbose --help
you see somewhere in the middle of the output (afte the option reference) these lines:

Default options are read from the following files in the given order:  
/etc/my.cnf /etc/opt/csw/my.cnf ~/.my.cnf

OpenCSW provides some example my.cnf files which can be found at: /opt/csw/share/mysql/my-*.sql
Copy and edit one of these files according to your needs.

permanent link
This answer is marked "community wiki".

answered 07 Feb '12, 16:12

AirOnSkin's gravatar image

AirOnSkin
966
accept rate: 66%

edited 12 Apr '13, 00:29

automaciej's gravatar image

automaciej ♦♦
93273037

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×5
×4

question asked: 07 Feb '12, 14:56

question was seen: 37,090 times

last updated: 18 Apr '13, 11:11

powered by OSQA