title: error initializing database (may take a long time) mysql server
body: <p>I'm trying installing MySQL server 8.0 (with error) and then uninstall it and trying to install 5.7 instead (I read people can get it works with 5.7) and the result is the same error. I don't know about the problem cause this is my first time using MySQL to learn it and stuck at the installation process. Here's the log of the installation process:</p>
  
  <pre><code>Beginning configuration step: Writing configuration file
  
  Saving my.ini configuration file...
  Saved my.ini configuration file.
  Ended configuration step: Writing configuration file
  
  Beginning configuration step: Updating Windows Firewall rules
  
  Adding a Windows Firewall rule for MySQL57 on port 3306.
  Attempting to add a Windows Firewall rule with command: netsh.exe advfirewall firewall add rule name="Port 3306" protocol=TCP localport=3306 dir=in action=allow
  Ok.
  
  
  Successfully added the Windows Firewall rule.
  Ended configuration step: Updating Windows Firewall rules
  
  Beginning configuration step: Adjusting Windows service
  
  Attempting to grant Network Service require filesystem permissions.
  Granted permissions.
  Adding new service
  New service added
  Ended configuration step: Adjusting Windows service
  
  Beginning configuration step: Initializing database (may take a long time)
  
  Attempting to run MySQL Server with --initialize-insecure option...
  Starting process for MySQL Server 5.7.29...
  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 --lower-case-table-names=1...
  2020-02-14T10:43:06.401608Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  2020-02-14T10:43:06.401673Z 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.
  2020-02-14T10:43:06.408061Z 0 [ERROR] InnoDB: Unable to create temporary file; errno: 0
  2020-02-14T10:43:06.408344Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
  2020-02-14T10:43:06.408444Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
  2020-02-14T10:43:06.408532Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
  2020-02-14T10:43:06.408617Z 0 [ERROR] Failed to initialize builtin plugins.
  2020-02-14T10:43:06.408711Z 0 [ERROR] Aborting
  Process for mysqld, with ID 15120, was run successfully and exited with code 1.
  Failed to start process for MySQL Server 5.7.29.
  Database initialization failed.
  Ended configuration step: Initializing database (may take a long time)
  </code></pre>
  
  <p>anyone knows what's the problem?</p>