Re: MySQL 8.0.28 Installer fails on create users on Windows Server 2019
Posted by: Edward Silha
Date: March 24, 2022 08:51AM

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

Options: ReplyQuote




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.