initializing mysql database:_MySql installation database initialization error

作者：Cpp五条 | 2024-06-13 07:32:08

踩

adding a windows firewall rule for mysql8.4 on port 3306. attempting to add

Im getting an error in the apply configuration part in the mySql installer community edition, it simply gives me and error after i execute with initializing the database, here is the log:

Beginning configuration step: Writing configuration file Ended configuration step: Writing configuration file

Beginning configuration step: Updating Windows Firewall rules Attempting to delete a Windows Firewall rule with command: netsh.exe advfirewall firewall delete rule name="Port 3306" protocol=TCP localport=3306

Deleted 1 rule(s). Ok.

Adding a Windows Firewall rule for MySQL80 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. Ended configuration step: Updating Windows Firewall rules

Beginning configuration step: Adjusting Windows service Attempting to grant Network Service require filesystem permissions. Granted permissions. Updating existing service Existing service updated Ended configuration step: Adjusting Windows service

Beginning configuration step: 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 FilesMySQLMySQL Server 8.0binmysqld.exe --defaults-file="C:ProgramDataMySQLMySQL Server 8.0my.ini" --console --initialize-insecure=on... 2018-07-06T00:43:22.829759Z 0 [ERROR] [MY-011071] [Server] Unknown suffix '.' used for variable 'lower_case_table_names' (value '0.0') 2018-07-06T00:43:22.829791Z 0 [ERROR] [MY-011071] [Server] C:Program FilesMySQLMySQL Server 8.0binmysqld.exe: Error while setting value '0.0' to 'lower_case_table_names' 2018-07-06T00:43:22.830226Z 0 [ERROR] [MY-010119] [Server] Aborting 2018-07-06T00:43:22.830354Z 0 [Note] [MY-010120] [Server] Binlog end Process for mysqld, with ID 12256, was run successfully and exited with code 1. Failed to start process for MySQL Server 8.0.11. Database initialization failed. Ended configuration step: Initializing Database

I would appreciate a reply soon, i kind of need it working now.

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/Cpp五条/article/detail/711432