Mysql启动配置文件加载路径
Mysql可以读取到的配置文件
/etc/my.cnf
/etc/mysql/my.cnf
/usr/local/mysql/etc/my.cnf
~/.my.cnf
(mysqld --verbose --help | grep my.cnf可以看到)
[root@edu mysql3306]# mysqld --defaults-file=/data/mysql/mysql3306/my3306.cnf --print-defaults
mysqld would have been started with the following arguments:
--user=mysql --basedir=/usr/local/mysql/ --datadir=/data/mysql/mysql3306/data --server_id=1893306 --port=3306 --character_set_server=utf8 --explicit_defaults_for_timestamp=off --log_timestamps=system --socket=/tmp/mysql3306.sock --read_only=0 --skip_name_resolve=1 --auto_increment_increment=1 --auto_increment_offset=1 --lower_case_table_names=1 --secure_file_priv= --open_files_limit=65536 --max_connections=1000 --thread_cache_size=64 --table_open_cache=81920 --table_definition_cache=4096 --t