How to Disable MySQL Strict Mode

To Disable MySQL Strict Mode, edit

Add under [mysqld] section

Verify MySQL Strict Mode

To check if MySQL is running in strict mode, run

You get empty result if MySQL is not running under strict mode.

Here is a MySQL server running under strict mode

After disabling MySQL strict mode

mysql

Need help with Linux Server or WordPress? We can help!

Leave a Reply

Your email address will not be published. Required fields are marked *