Live Chat Software by Kayako |
Base de Conocimientos
Disable MySQL strict mode
Escrito por Santiago A. Gonzalez el 16 July 2019 05:35 PM
|
|
2. Disable Strict Mode via my.cnf: Disable it by setting your own SQL_MODE in the my.cnf file, then restart MySQL. The my.cnf file can be found in one of a few locations (depending on which distribution you're using). The most common locations are /etc/my.cnf and /etc/mysql/my.cnf. Inside my.cnf, look for a heading like [mysqld] and then look for the value of sql_mode. It might look like this (the actual value of sql_mode may vary): sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES You can change the value of sql_mode to NO_ENGINE_SUBSTITUTION to completely disable strict mode, but you may want to look up each mode that is configured before disabling it. If sql_mode isn't set, you can add it under the [mysqld] heading, then save the file, and restart MySQL. | |
|