Re: MySQL 8.0.28 Installer fails on create users on Windows Server 2019

[Edward Silha]

There is no data in general_log.CSV, nothing

The slow.log contains this...

C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe, Version: 8.0.28 (MySQL Community Server - GPL). started with:
TCP Port: 0, Named Pipe: MySQL
Time Id Command Argument
C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe, Version: 8.0.28 (MySQL Community Server - GPL). started with:
TCP Port: 3306, Named Pipe: MySQL
Time Id Command Argument



The error log contains this

2022-03-24T02:36:29.969861Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2022-03-24T02:36:29.971171Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.28) starting as process 1624
2022-03-24T02:36:29.990491Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-03-24T02:36:30.123422Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2022-03-24T02:36:30.311708Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2022-03-24T02:36:30.312382Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2022-03-24T02:36:30.338121Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060
2022-03-24T02:36:30.338209Z 0 [System] [MY-010931] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: ready for connections. Version: '8.0.28' socket: '' port: 3306 MySQL Community Server - GPL.


I cannot create users manually, I cannot log into workbench w/ root