Почему при установке сервера mysql появляется ошибка инициализации базы данных?
привет,
я пытаюсь установить сервер MySQl, но во время настройки на этом шаге появляется ошибка "инициализация базы данных".b
это и есть журнал:
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]
Что я уже пробовал:
я удалил его и перезагрузил компьютер, а также удалил все файлы MySQL в данных приложения и программных файлах, а затем попытался установить его снова, но появилась та же ошибка.