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.
[12 Jul 2018 14:32]
Chiranjeevi Battula
Hello Pradnyankur,
Thank you for the bug report.
This is most likely duplicate of Bug #91476, please see Bug #91476
Thanks,
Chiranjeevi.
[23 Oct 2022 16:22]
Akarsh sharma
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.
[24 Oct 2022 5:52]
Pradnyankur Nikam
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
Portions of this website are
copyright © 2001, 2002 The PHP Group
Page generated in 0.014 sec. using MySQL 8.0.36-u4-cloud
Timestamp references displayed by the system are UTC.
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
