MySQL Forums
Forum List  »  Newbie

Strict Mode Disabled - Will not start up
Posted by: Ronald Kaylor
Date: July 20, 2021 07:11AM

We have a MySQL Server and we had an issue and we need to disable Strict Mode. As soon as I change sql_mode= "" in my.ini file and I restart the server MySQL hangs in starting.

This is running on Microsoft Server 2008

The service stays in Starting but I see it in Task Manage but the database is not responsive.

I put the file back that had the sql_mode = "STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" and it books back up as normal.

I need to disable strict mode but not sure why it will not boot up if I do?

Thank you for any help.

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.