Problem with MySQL server


  • | 643 points

    Hello folks,

    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"


  • | 643 points

    @Shifrin It's had been fixed by setting temp directory to the my.ini file under the [mysqld] like this below:

    [mysqld]
    tmpdir="D:/laragon/tmp"
    

    The drive and folder will depend on your installation.

    Thank you @leokhoa, for helping me via TeamViewer to fix this issue.


Log in to reply
 

Looks like your connection to Laragon was lost, please wait while we try to reconnect.