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:
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?