MySQL Forums
Forum List  »  Newbie

Re: Strict Mode Disabled - Will not start up
Posted by: Ronald Kaylor
Date: July 20, 2021 08:27AM

I did at the page stated you sent me to:

Setting the SQL Mode

The default SQL mode in MySQL 8.0 includes these modes: ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, and NO_ENGINE_SUBSTITUTION.

To set the SQL mode at server startup, use the --sql-mode="modes" option on the command line, or sql-mode="modes" in an option file such as my.cnf (Unix operating systems) or my.ini (Windows). modes is a list of different modes separated by commas. To clear the SQL mode explicitly, set it to an empty string using --sql-mode="" on the command line, or sql-mode="" in an option file.

I did the: sql-mode="" in an option file. my.ini file.

Then I restart the server and it will not boot up just sits in Starting.

Are you saying there is also a setting I need to make on the server somewhere beside this file?

Thank you,
Ron

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.