Click here to Skip to main content
15,886,362 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
MySQL Server Can't run

Version: 5.7.21
OS: Windows 10 Pro, also Windows 11 Pro



What I have tried:

First: I tried to auto-install MySQL Server 5.7.21 using Advanced installer after the installation was completed, but the server doesn't run.

Log:
2022-09-29T08:53:05.452306Z 0 [Warning] option 'read_buffer_size': unsigned value 0 adjusted to 8192
2022-09-29T08:53:05.452464Z 0 [Warning] option 'read_rnd_buffer_size': unsigned value 0 adjusted to 1
2022-09-29T08:53:05.452586Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2022-09-29T08:53:05.452624Z 0 [Warning] '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-09-29T08:53:05.457295Z 0 [Note] C:\Program Files (x86)\MySQL\MySQL Server 5.7\bin\mysqld.exe (mysqld 5.7.21-log) starting as process 8916 ...
2022-09-29T08:53:05.480808Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-09-29T08:53:05.482325Z 0 [Note] InnoDB: Uses event mutexes
2022-09-29T08:53:05.483397Z 0 [Note] InnoDB: Memory barrier is not used
2022-09-29T08:53:05.484493Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2022-09-29T08:53:05.485652Z 0 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB
2022-09-29T08:53:05.488209Z 0 [Note] InnoDB: Number of pools: 1
2022-09-29T08:53:05.489572Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2022-09-29T08:53:05.495812Z 0 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M
2022-09-29T08:53:05.498970Z 0 [Note] InnoDB: Completed initialization of buffer pool
2022-09-29T08:53:05.523972Z 0 [ERROR] InnoDB: Header page consists of zero bytes in datafile: .\ibdata1, Space ID:0, Flags: 0. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2022-09-29T08:53:05.527915Z 0 [ERROR] InnoDB: Corrupted page [page id: space=0, page number=0] of datafile '.\ibdata1' could not be found in the doublewrite buffer.
2022-09-29T08:53:05.530377Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2022-09-29T08:53:05.864803Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-09-29T08:53:05.866551Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-09-29T08:53:05.868355Z 0 [ERROR] Failed to initialize builtin plugins.
2022-09-29T08:53:05.869782Z 0 [ERROR] Aborting

2022-09-29T08:53:05.870802Z 0 [Note] Binlog end
2022-09-29T08:53:05.872100Z 0 [Note] Shutting down plugin 'CSV'
2022-09-29T08:53:05.874132Z 0 [Note] C:\Program Files (x86)\MySQL\MySQL Server 5.7\bin\mysqld.exe: Shutdown complete



Second I tried to install it Manullay but the server can't run also.

Log:
Beginning configuration step: Stopping Server [if necessary]
Ended configuration step: Stopping Server [if necessary]

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

Beginning configuration step: Updating firewall
Attempting to create firewall rule with command: netsh.exe  firewall delete portopening protocol=TCP port=3306 profile=ALL
Adding firewall rule for VatoceMySQL57 on port 3309.
Attempting to create firewall rule with command: netsh.exe  firewall add portopening protocol=TCP port=3309 profile=ALL name=VatoceMySQL57 mode=ENABLE scope=ALL
Successfully added firewall rule.
Ended configuration step: Updating firewall

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

Beginning configuration step: Initializing Database [if necessary]
Deleting the data directory from a previous (failed) configuration...
Attempting to run MySQL Server with --initialize-insecure option...
Starting process for MySQL Server 5.7.21...
Starting process with command: C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" --console --initialize-insecure=on...
2022-09-29T09:09:12.472798Z 0 [Warning] option 'read_buffer_size': unsigned value 0 adjusted to 8192
2022-09-29T09:09:12.473993Z 0 [Warning] option 'read_rnd_buffer_size': unsigned value 0 adjusted to 1
2022-09-29T09:09:12.474064Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2022-09-29T09:09:12.474097Z 0 [Warning] '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-09-29T09:09:12.668593Z 0 [ERROR] InnoDB: Operating system error number 87 in a file operation.
2022-09-29T09:09:12.669785Z 0 [ERROR] InnoDB: File .\ib_logfile101: 'aio write' returned OS error 187. Cannot continue operation
2022-09-29T09:09:12.670071Z 0 [ERROR] InnoDB: Cannot continue operation.
Process for mysqld, with ID 2724, was started successfully and exited with code 3.
Database initialization failed.
Ended configuration step: Initializing Database [if necessary]



Finally I tried another PC and it work Successfully. but what are the reasons that I can tell the customer?
Posted
Comments
Michael_Davies 30-Sep-22 2:38am    
Try adding innodb_flush_method=normal to the ini.
Golden Basim 30-Sep-22 5:03am    
I tried that, Initializing Database Passed Successfully but it stopped at Starting Services step (no error appears)
Michael_Davies 30-Sep-22 5:10am    
What partition type is MySQL installed on the working and the non-working, there were issues with GPT partitions.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900