MySQL Forums
Forum List  »  Newbie

Re: Strict Mode Disabled - Will not start up
Posted by: Jon Stephens
Date: July 21, 2021 07:22AM

I don't think you followed my instructions, so let me see if I can make it clearer:

1. Start the MySQL server using your original configuration file.

2. Once the server is running, log in to the server using the mysql client. Then change the SQL mode from there using
SET @@sql_mode = '...'
(replace the ... with your desired SQL mode or modes). You'll probably want to do this as the MySQL root user, so that the mode is enforced for all users.

This may not work as you'd like, but it might get you up & running temporarily, for now. The proper solution is to make your applications compliant with strict mode.

Strict mode became the default in MySQL 5.7, that remains the case in MySQL 8.0, and I am at least 99% sure that this is never, ever going to change in future versions. The fact that we ever supported anything other than strict mode as the default was a serious mistake, which we've now rectified.

(Note to Peter B: Feel free to step in here and preach a sermon on data integrity. ;-) )


Jon Stephens
MySQL Documentation Team @ Oracle
Orlando, Florida, USA

MySQL Dev Zone
MySQL Server Documentation

Options: ReplyQuote

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.