Re: settings in my.ini crashing server (start as a service in windows) (MySQL 5.7)

[Rimak Nusil]

this is the result:



--
C:\Program Files\MySQL\MySQL Server 5.7\bin>mysqld -defaults -file="C:\ProgramDa
ta\MySQL\MySQL Server 5.7\my.ini" -colsole

mysqld: Can't change dir to 'C:\Program Files\MySQL\MySQL Server 5.7\data\' (Err
code: 2 - No such file or directory)
2016-03-01T12:37:22.453667Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is
deprecated. Please use --explicit_defaults_for_timestamp server option (see doc
umentation for more details).
2016-03-01T12:37:22.453667Z 0 [Warning] Insecure configuration for --secure-file
-priv: Current value does not restrict location of generated files. Consider set
ting it to a valid, non-empty path.
2016-03-01T12:37:22.453667Z 0 [Note] mysqld (mysqld 5.7.11) starting as process
7140 ...
2016-03-01T12:37:22.455668Z 0 [Warning] Can't create test file C:\Program Files\
MySQL\MySQL Server 5.7\data\CBI03043.lower-test
2016-03-01T12:37:22.456316Z 0 [Warning] Can't create test file C:\Program Files\
MySQL\MySQL Server 5.7\data\CBI03043.lower-test
2016-03-01T12:37:22.457318Z 0 [ERROR] failed to set datadir to C:\Program Files\
MySQL\MySQL Server 5.7\data\
2016-03-01T12:37:22.458319Z 0 [ERROR] Aborting

2016-03-01T12:37:22.458319Z 0 [Note] Binlog end
2016-03-01T12:37:22.458319Z 0 [Note] mysqld: Shutdown complete


C:\Program Files\MySQL\MySQL Server 5.7\bin>

--

-> But there is a "Data" folder which was created after the installation

and:
If I start the service only with the my-defaufts.ini (all my.ini files deleted) then it usually works and I can change the schema in the workbench GUI to utfmb4.

If I edit the my-default to use utf8mb4 instead og utf8, then the service crashes.

Now the content of the my.ini is unchanged and the same as in the my-default.ini (so service works)