$ which mysqld
/usr/local/bin/mysqld
$ mysqld --verbose --help | grep -A 1 'Default options'
2016-01-03 11:12:54 4947 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
2016-01-03 11:12:54 4947 [Note] Plugin 'FEDERATED' is disabled.
Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf /usr/local/etc/my.cnf ~/.my.cnf
2016-01-03 11:12:54 4947 [Note] Binlog end
2016-01-03 11:12:54 4947 [Note] Shutting down plugin 'MyISAM'
2016-01-03 11:12:54 4947 [Note] Shutting down plugin 'CSV'
Created
January 3, 2016 02:17
-
-
Save libitte/1168311a67f2b35ca0df to your computer and use it in GitHub Desktop.
Which default options are read from the mysql configuration files
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment