Click here to Skip to main content
15,884,693 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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]


What I have tried:

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.
Posted
Updated 6-Jun-20 7:55am

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

You should try to ask their support service.
Chances are that they know better than us.
 
Share this answer
 
File 'C:\Users\Public\Documents\Wondershare\CreatorTemp\ib9E78.tmp' not found (Errcode: 13 - Permission denied)
There is the issue.

If I were confronted to this problem, I would try to install MySql using genuine original channel, and avoid using some sort of app installer (namely: wondershare) which may install God-knows-what onto my system:
MySql Community Downloads[^]
 
Share this answer
 
I changed my computer name from Chinese to English and it worked!
 
Share this answer
 

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