How To Determine Where MySQL Looks For my.cnf

Ah, the power of grep!
1 |
mysql --help | grep 'Default options' -A 1 |
![]() |
Ah, the power of grep!
1 |
mysql --help | grep 'Default options' -A 1 |
[root@db1 ~]# service mysqld stop [root@db1 ~]# cd /var/lib/mysql [root@db1 mysql]# ls -l ib_logfile? -rw-rw—- 1 mysql mysql 5242880 Oct 29 23:00 ib_logfile0 -rw-rw—- 1 mysql mysql 5242880 Oct 29 22:38 ib_logfile1 [root@db1 mysql]# mv ib_logfile0 ib_logfile0.old [root@db1 mysql]# mv ib_logfile1 ib_logfile1.old [root@db1 ~]# vi /etc/my.cnf innodb_log_file_size=64M # comment out the old value, if one […]
/usr/sbin/mysqld –verbose –help | grep -A 1 “Default options”
YMMV… /usr/share/doc/mysql-server-5.1.52