This is a continuation of the previous blog entry but now I am going to assume that you have your MySQL 5.5.8 software installed but not started – yet.
Why option files?
The MySQL server can be run with options provided on the command line and any DBA who has been around the job for a while will know –skip-grant-tables. Most instances run with too many options to input the desired options by hand over and over again. So most people use a option file to keep the configuration information.
What is the option file named?
Windows instances will have a my.ini file.
*NIX instances will have a my.cnf,
But that configuration file name can be changed on the command line.
Where are these files found?
Windows folks will should start to look in [Read more...]