Re: Strict Mode Disabled - Will not start up

[Ronald Kaylor]

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