How to fix World-writable config file /etc/my.cnf is ignored?
The default configuration file of MySql is my.cnf (location: /etc/my.cnf for Linux) and my.cfg (location: Program File/MySql for windows). For utf-8 supported database, there must be an entry of UTF-8 parameter in my.cfg file.
But sometime mysql does use the my.cnf file from other location than /etc/my.cnf. If you change the required parameter in /etc/my.cnf file, it may not be reflected in database. An error: 'World-writable config file /etc/my.cnf is ignored' will come while executing the mysqld demon.
Just change its permission
and execute the mysqld demon.
$ mysqld start
Ref:
http://hecode.com/how-to-fix-world-writable-config-file-etcmy-cnf-is-ignored/
http://dev.mysql.com/doc/refman/5.1/en/linux-installation-rpm.html
But sometime mysql does use the my.cnf file from other location than /etc/my.cnf. If you change the required parameter in /etc/my.cnf file, it may not be reflected in database. An error: 'World-writable config file /etc/my.cnf is ignored' will come while executing the mysqld demon.
Just change its permission
.$ chmod 644 /etc/my.cnfand execute the mysqld demon.
$ mysqld start
Ref:
http://hecode.com/how-to-fix-world-writable-config-file-etcmy-cnf-is-ignored/
http://dev.mysql.com/doc/refman/5.1/en/linux-installation-rpm.html
Comments