Problem with MySQL server
I'm having trouble with MySQL server from last 2 days. It suddenly stops working and I have tried some several fixes but couldn't make it to work. I also tried other versions like 5.7.29 and MariaDB 10.4.13, but no luck. When I have changed the other version it's stuck on "Initializing Data"...
The MySQL log for version 5.7.24 which comes with Laragon latest:
2020-06-07T09:26:58.109157Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path. 2020-06-07T09:26:58.110050Z 0 [Note] D:\local_development\bin\mysql\mysql-5.7.24-winx64\bin\mysqld (mysqld 5.7.24) starting as process 5384 ... 2020-06-07T09:27:07.524421Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path. 2020-06-07T09:27:07.525098Z 0 [Note] D:\local_development\bin\mysql\mysql-5.7.24-winx64\bin\mysqld (mysqld 5.7.24) starting as process 14508 ... 2020-06-07T09:27:07.555614Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2020-06-07T09:27:07.556777Z 0 [Note] InnoDB: Uses event mutexes 2020-06-07T09:27:07.557532Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier 2020-06-07T09:27:07.558635Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2020-06-07T09:27:07.559990Z 0 [Note] InnoDB: Number of pools: 1 2020-06-07T09:27:07.560852Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2020-06-07T09:27:07.561845Z 0 [ERROR] InnoDB: Unable to create temporary file; errno: 2 2020-06-07T09:27:07.562779Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error 2020-06-07T09:27:07.563810Z 0 [ERROR] Plugin 'InnoDB' init function returned error. 2020-06-07T09:27:07.564693Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2020-06-07T09:27:07.565661Z 0 [ERROR] Failed to initialize builtin plugins. 2020-06-07T09:27:07.566458Z 0 [ERROR] Aborting 2020-06-07T09:27:07.567126Z 0 [Note] Binlog end 2020-06-07T09:27:07.567773Z 0 [Note] Shutting down plugin 'CSV' 2020-06-07T09:27:07.576391Z 0 [Note] D:\local_development\bin\mysql\mysql-5.7.24-winx64\bin\mysqld: Shutdown complete
Please any help on this to fix this issue will be highly appreciated. BTW I have tried the fresh installation of Laragon and when starts MySQL server it stops on "Initializing Data"
@Shifrin It's had been fixed by setting temp directory to the my.ini file under the [mysqld] like this below:
The drive and folder will depend on your installation.
Thank you @leokhoa, for helping me via TeamViewer to fix this issue.