Strict Mode Disabled - Will not start up
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.
Ron
Subject
Written By
Posted
Strict Mode Disabled - Will not start up
July 20, 2021 07:11AM
Sorry, you can't reply to this topic. It has been closed.
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.