Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

This question is an exact duplicate of:

I have installed MySQL and i am trying to understand few things:

  • The is several configuration *.ini files, Does the server automatically choose one of them or this files used as templates and i should create my.ini file with my own configuration.
  • If i should create my own my.ini file so doe's the server automatically look for my.ini, Is there a way i can rename the .ini file as i want and configure MySQL to look for myAnother.ini

If anyone can help me here please i will be very thankful, Thank you all and have a nice day.

share|improve this question

marked as duplicate by Michael Hampton, dunxd, mgorven, Dave M, TheCleaner Feb 22 '13 at 22:30

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

Please do not post the same question twice. If your original question did not get an answer, see the FAQ for guidance on how to edit and improve it. – Michael Hampton Feb 22 '13 at 6:28
Thank you Michael. – Aviel Fedida Feb 22 '13 at 6:30
up vote 1 down vote accepted

The server will not automatically "search" for any .ini file.

There are multiple levels where the .ini files are specified.

  1. During compilating the configure script takes certain parameters which can set the default paths where the mysqld binary will look for .ini files on startup.

  2. During startup of the mysqld binary it will check for the config files at the defined default paths, unless you specify them via --defaults-file or --defaults-extra-file.

  3. In many distributions there are configuration files to tell the init scripts to pass alternative config file paths to the mysqld on startup, using the same parameters as the 2. point.

Howto know the defaults of your compiled binary?

When you do this you see it specified in the first 10 lines of the output: mysqld --help --verbose | more

share|improve this answer
Thank you so much mauro, I have looking for an answer, have a nice day. – Aviel Fedida Feb 22 '13 at 9:08

Not the answer you're looking for? Browse other questions tagged or ask your own question.