In this blog post, I’ll look at how to use the loose_ option prefix in my.cnf in MySQL.
mysqld throws errors at startup – and refuses to start up – if a non-existent options are defined in the my.cnf file.
For example:
2016-10-05 15:56:07 23864 [ERROR] /usr/sbin/mysqld: unknown variable 'bogus_option=1'
The MySQL manual has a solution: use
the loose_ prefix option in my.cnf file.
In the prior example, if we specify
loose_bogus_option=1 in the my.cnf file, instead of
bogus_option=1, mysqld starts successfully and
ignores that option.
This is useful in three situations:
- Using …