Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

MySQL config file location - redhat linux server [closed]

What is the default location for the MySQL configuration file on a redhat linux box?

like image 650
user42931 Avatar asked Dec 04 '08 18:12

user42931


People also ask

Where is MySQL config stored Linux?

On RH systems, MySQL configuration file is located under /etc/my. cnf by default.

What is configuration file of MySQL?

Most MySQL programs can read startup options from option files (sometimes called configuration files). Option files provide a convenient way to specify commonly used options so that they need not be entered on the command line each time you run a program.


2 Answers

Just found it, it is /etc/my.cnf

like image 166
user42931 Avatar answered Oct 07 '22 02:10

user42931


The information you want can be found by running

mysql --help 

or

mysqld --help --verbose 

I tried this :

    mysql --help | grep Default -A 1 

And the output:

                      (Defaults to on; use --skip-auto-rehash to disable.)   -A, --no-auto-rehash  --                       (Defaults to on; use --skip-line-numbers to disable.)   -L, --skip-line-numbers  --                       (Defaults to on; use --skip-column-names to disable.)   -N, --skip-column-names  --                       (Defaults to on; use --skip-reconnect to disable.)   -s, --silent        Be more silent. Print results with a tab as separator, --   --default-auth=name Default authentication client-side plugin to use.   --binary-mode       By default, ASCII '\0' is disallowed and '\r\n' is -- Default options are read from the following files in the given order: /etc/my.cnf /etc/mysql/my.cnf /usr/etc/my.cnf ~/.my.cnf  
like image 35
ThinkingMonkey Avatar answered Oct 07 '22 02:10

ThinkingMonkey