New Install of Laragon. MYSQL fails after a few seconds on startup.


  • | 604 points

    Installing Laragon on Windows 10 Pro version 1909. When I finish the install and start Laragon services, MySQL shows red and says "Failed: MySQL mysql-5.7.24-winx64". Been Googling around for the past hour and tried a few different things but still having the same issue. Laragon is installed on my Windows 10 laptop with no issues. Any help would be greatly appreciated.

    Here is what my mysql.log file says.

    2020-02-11T00:33:00.035478Z 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-02-11T00:33:00.035860Z 0 [Note] C:\laragon\bin\mysql\mysql-5.7.24-winx64\bin\mysqld (mysqld 5.7.24) starting as process 3496 ...
    2020-02-11T00:33:10.068016Z 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-02-11T00:33:10.068360Z 0 [Note] C:\laragon\bin\mysql\mysql-5.7.24-winx64\bin\mysqld (mysqld 5.7.24) starting as process 7732 ...
    2020-02-11T00:33:10.092893Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
    2020-02-11T00:33:10.093490Z 0 [Note] InnoDB: Uses event mutexes
    2020-02-11T00:33:10.093851Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
    2020-02-11T00:33:10.094385Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
    2020-02-11T00:33:10.095096Z 0 [Note] InnoDB: Number of pools: 1
    2020-02-11T00:33:10.095561Z 0 [Note] InnoDB: Not using CPU crc32 instructions
    2020-02-11T00:33:10.100237Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
    2020-02-11T00:33:10.105646Z 0 [Note] InnoDB: Completed initialization of buffer pool
    2020-02-11T00:33:10.133849Z 0 [ERROR] InnoDB: Header page consists of zero bytes in datafile: .\ibdata1, Space ID:0, Flags: 0. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
    2020-02-11T00:33:10.135102Z 0 [ERROR] InnoDB: Corrupted page [page id: space=0, page number=0] of datafile '.\ibdata1' could not be found in the doublewrite buffer.
    2020-02-11T00:33:10.135956Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
    2020-02-11T00:33:10.480682Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
    2020-02-11T00:33:10.483164Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
    2020-02-11T00:33:10.485777Z 0 [ERROR] Failed to initialize builtin plugins.
    2020-02-11T00:33:10.487919Z 0 [ERROR] Aborting

    2020-02-11T00:33:10.489442Z 0 [Note] Binlog end
    2020-02-11T00:33:10.491043Z 0 [Note] Shutting down plugin 'CSV'
    2020-02-11T00:33:10.518532Z 0 [Note] C:\laragon\bin\mysql\mysql-5.7.24-winx64\bin\mysqld: Shutdown complete


  • administrators
    | 118581 points

    @stewblack23 :

    2020-02-11T00:33:10.133849Z 0 [ERROR] InnoDB: Header page consists of zero bytes in datafile: .\ibdata1, Space ID:0, Flags: 0. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
    

    Can you rename C:\laragon\data to C:\laragon\data.bak and try again?


  • | 604 points

    @leokhoa Renamed laragon\data to laragon\data.bak restarted MySQL and still get the same error. Laragon created a new data folder.


  • | 604 points

    @leokhoa Figured out the issue. You will have to make edits to your my.ini file. That file is located in /laragon/bin/mysql/mysql-5.7.24-winx64/my.ini. In your my.ini file under [mysqld] title add these two lines "default-storage-engine=MyISAM" and "skip-innodb" and save the file. Now your my.ini file should look something like this.

    [mysqld]
    default-storage-engine=MyISAM
    port=3306
    socket=/tmp/mysql.sock
    key_buffer_size=256M
    max_allowed_packet=512M
    table_open_cache=256
    sort_buffer_size=1M
    read_buffer_size=1M
    read_rnd_buffer_size=4M
    myisam_sort_buffer_size=64M
    thread_cache_size=8
    lower_case_table_names=2
    innodb_flush_method=normal
    skip-innodb

    Once you have saved the file. You now want to delete all the files in laragon/data/mysql folder. Laragon creates all the data files in this folder. Now restart MySQL and your issue should be fixed. See this link for further help. http://webdevelopmentscripts.com/23-solved-innodb-error-space-header-page-consists-of-zero-bytes-xampp


  • | 604 points

    @stewblack23 Also restart your machine and go back into your my.ini file and "remove default-storage-engine=MyISAM" and "skip-innodb" MySQL 5.7 > needs InnoDB to run correctly. However MySQL failing in Laragon should be fixed.


  • administrators
    | 118581 points

    @stewblack23 : I'm glad that you found the issue and fixed it. Also, many thanks for reporting how you fixed that. It is very helpful.
    Do you have any suggestion to auto fix it with Laragon?


Log in to reply
 

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