Why initializing database error appear during installing mysql server?
Posted by: Bassem Melek
Date: December 27, 2019 01:36PM

hi,

i try to install MySQl Server but an error appear during the configurations at this step "Initializing Database".b


this is the 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 MySQL57 on port 3309.
Attempting to create firewall rule with command: netsh.exe firewall add portopening protocol=TCP port=3309 profile=ALL name=MySQL57 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...
2019-12-27T11:53:44.894282Z 0 [Warning] option 'read_buffer_size': unsigned value 0 adjusted to 8192
2019-12-27T11:53:44.894326Z 0 [Warning] option 'read_rnd_buffer_size': unsigned value 0 adjusted to 1
2019-12-27T11:53:44.894358Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-12-27T11:53:44.894366Z 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.
mysqld: File 'C:\Users\Public\Documents\Wondershare\CreatorTemp\ib9E78.tmp' not found (Errcode: 13 - Permission denied)
2019-12-27T11:53:44.902762Z 0 [ERROR] InnoDB: Unable to create temporary file; errno: 13
2019-12-27T11:53:44.903251Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2019-12-27T11:53:44.903343Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-12-27T11:53:44.903439Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-12-27T11:53:44.903516Z 0 [ERROR] Failed to initialize builtin plugins.
2019-12-27T11:53:44.903597Z 0 [ERROR] Aborting
Process for mysqld, with ID 17160, was started successfully and exited with code 1.
Database initialization failed.
Ended configuration step: Initializing Database [if necessary]



i uninstalled it & restart the computer also i deleted all MySQL files in the application data and program files then i tried to install it again but the same error appear.

Options: ReplyQuote


Subject
Views
Written By
Posted
Why initializing database error appear during installing mysql server?
5172
December 27, 2019 01:36PM


Sorry, you can't reply to this topic. It has been closed.

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 Oracle or any other party.