MySQL Bugs: #109368: error in Installing 8.0.31.0

Bug #109368	error in Installing 8.0.31.0
Submitted:	13 Dec 2022 18:58	Modified:	16 Jan 2023 13:18
Reporter:	Jason Saggs	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S1 (Critical)
Version:	8.0.31.0	OS:	Windows (Windows 11)
Assigned to:	MySQL Verification Team	CPU Architecture:	Any

Description:
Error during Configuration and Initialization.

Beginning configuration step: Writing configuration file

Saving my.ini configuration file...
Saved my.ini configuration file.
Ended configuration step: Writing configuration file

Beginning configuration step: Updating Windows Firewall rules

Adding a Windows Firewall rule for MySQL81 on port 3306.
Attempting to add a Windows Firewall rule with command: netsh.exe advfirewall firewall add rule name="Port 3306" protocol=TCP localport=3306 dir=in action=allow
Ok.

Successfully added the Windows Firewall rule.
Adding a Windows Firewall rule for MySQL81 on port 33060.
Attempting to add a Windows Firewall rule with command: netsh.exe advfirewall firewall add rule name="Port 33060" protocol=TCP localport=33060 dir=in action=allow
Ok.

Successfully added the Windows Firewall rule.
Ended configuration step: Updating Windows Firewall rules

Beginning configuration step: Adjusting Windows service

Attempting to grant Network Service require filesystem permissions.
Granted permissions.
Adding new service
New service added
Ended configuration step: Adjusting Windows service

Beginning configuration step: Initializing database (may take a long time)

Attempting to run MySQL Server with --initialize-insecure option...
Starting process for MySQL Server 8.0.31...
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 --lower-case-table-names=1...
Using jemalloc.dll for my_malloc and ut::malloc etc.
C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Empty value for 'open_files_limit' specified.
Process for mysqld, with ID 16104, was run successfully and exited with code 1.
Failed to start process for MySQL Server 8.0.31.
Database initialization failed.
Ended configuration step: Initializing database (may take a long time)

How to repeat:
Appy My Configuration in MySQL Installer

Hello Jason Saggs,

Thank you for the bug report.
I tried to reproduce your issue on windows 10 with MySQL Installer and tried to install MySQL server 8.0.31 but I am not seeing any issues at my end.

Regards,
Ashwini Patil

Thank you for your time and effort Ashwini.

To confirm my OS is Windows11, not Windows10

To anybody who might run into this issue, the below has allowed the install:-

Open the my.ini configuration file that should be found in the following folder:

"C:\ProgramData\MySQL\MySQL Server <version>\my.ini"

Then, open the file and at the end, add the phrase lower_case_table_names=1 (or, if it is already there but it equals a different value, set it up to equal 1).

Finally, save the file and try installing MySQL again.

Hello Jason Saggs,

Thank you for the details.
Could you please provide unaltered MySQL server error log file?

Regards,
Ashwini Patil

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".