MySQL Bugs: #91615: MySQL 8.0.11 database initialization failed with Unknown suffix error

Bug #91615	MySQL 8.0.11 database initialization failed with Unknown suffix error
Submitted:	12 Jul 2018 11:32	Modified:	24 Oct 2022 5:52
Reporter:	Pradnyankur Nikam	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S3 (Non-critical)
Version:	8.0.11	OS:	Windows
Assigned to:		CPU Architecture:	Any
Tags:	Database Initiallization Error, MySQL 8.0.11, Unknown suffix

Description:
Hello MySQL Team,

I've MySQL 8.0.11 installation video on YouTube. Here is the link,
https://www.youtube.com/watch?v=Ddx13KlW8yQ

From the last couple of weeks several user are reporting "Database Initialization Error". Some users provided the following error log.

Initializing Database
Attempting to run MySQL Server with --initialize-insecure option...
Starting process for MySQL Server 8.0.11...
Starting process with command:
C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 8.0\my.ini" --console --initialize-insecure=on...
2018-07-12T04:00:27.826018Z 0
[ERROR] [MY-011071] [Server] Unknown suffix '.' used for variable 'lower_case_table_names' (value '0.0') 2018-07-12T04:00:27.826095Z 0
[ERROR] [MY-011071] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Error while setting value '0.0' to 'lower_case_table_names' 2018-07-12T04:00:27.827281Z 0
[ERROR] [MY-010119] [Server] Aborting 2018-07-12T04:00:27.827578Z 0 [Note] [MY-010120] [Server] Binlog end Process for mysqld, with ID 11248, was run successfully and exited with code 1.
Failed to start process for MySQL Server 8.0.11. 
Database initialization failed.

I couldn't find any solution on this error. Therefore, unable to help my students. Can you please help me and my students fix this error message?

Looking forward to hear from you.

Regards,
Pradnyankur Nikam

How to repeat:
Install MySQL 8.0.11 on Windows 7, Windows 10 operating system.

Hello Pradnyankur,

Thank you for the bug report.
This is most likely duplicate of Bug #91476, please see Bug #91476

Thanks,
Chiranjeevi.

I am facing this issue & not able to install Mysql Server in my PC , Please Help me to figure it out.

Attachment: WhatsApp Image 2022-10-23 at 21.22.56.jpeg (image/jpeg, text), 89.21 KiB.

Hi Akarsh,

Uninstall the latest failed/unsuccessful MySQL database (8.0.31) from your computer and install previous stable release like, 8.0.25 version. I've given details video tutorials about both on my YouTube channel, you can check it out.

Let me know if it works.

Regards,
Pradnyankur Nikam