MySQL Server configuration files

The list of MySQL Server configuration files. This includes both Active and Inactive configuration files.

Active configuration files
1  in  /etc/
1  in  /usr/local/mysql/bin/

Inactive configuration files
3  in  /usr/local/mysql/support-files/
2  in  /usr/local/mysql/sql-bench/

 

 

Active Configuration files
/etc/
my.cnf
Standard MySQL Server configuration file.
NOTE: This is actually a copy of the file my-default.cnf in the support-files section.


/usr/local/mysql/bin/

mysqlaccess.conf
Configuration file read by mysqlaccess during initialisation.
NOTE:
This file can also be place in /etc/ to work.
This file strangely has an executable permission set.

 

 

Inactive Configuration files
/usr/local/mysql/support-files/
magic
Contains the magic bytes for different MySQL file types
NOTE: Contents of this file should be placed in the /etc/magic for the file command to recognize different MySQL file types. But CentOS DVD installation by default recognizes all file types given in this file, so there is no need for this.

my-default.cnf
The default MySQL Server configuration file
NOTE: For this configuration file to work, it must be copied to /etc/my.cnf with proper changes made.

mysql-log-rotate
MySQL Server logrotate script
NOTE:
For this script to work, it should be placed in /etc/logrotate.d/ directory with proper changes made to /etc/my.cnf configuration file.
This file strangely has an executable permission set.


/usr/local/mysql/sql-bench/
bench-init.pl
Base file every test is using
NOTE: This file strangely has an executable permission set.

server-cfg
Configuration file for the DBI/DBD tests on different databases
NOTE: This file strangely has an executable permission set.

 

 

You may go back to the following section.
Installing MySQL Server