How to add MySQL 5.5 / 5.6


  • | 303 points

    I'm unable to start an older version of MySQL in laragon.
    With MySQL version 5.6 I get the following error in the first run:
    [ERROR] C:\laragon\bin\mysql\mysql-5.6.37-winx64\bin\mysqld.exe: unknown option '--initialize-insecure'

    When I run mysqld --initialize manually, I can initialize the database.
    However I'm still unable to start the service from laragon.
    When I start the service, after initializing it manually, I get the following error:
    [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist/

    Unfortunately using MySQL 5.7 is not an option because some sql_mode options are no longer working.

    How am I able to use MySQL versions before 5.7 on laragon?


  • administrators
    | 66271 points

    @ZeroMD
    You can try deleting the C:\laragon\data\mysql dir and then re-initialize MySQL 5.6 on that dir.


  • | 303 points

    @leokhoa said in How to add MySQL 5.5 / 5.6:

    @ZeroMD
    You can try deleting the C:\laragon\data\mysql dir and then re-initialize MySQL 5.6 on that dir.

    I already did that manually, but when I start the service from laragon, I get the folowing error:
    [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist/


  • administrators
    | 66271 points

    @ZeroMD : You may try download Laragon portable:
    https://sourceforge.net/projects/laragon/files/Portable/laragon-3.1.7z

    Extract it and copy the data dir to the location.


  • | 303 points

    @leokhoa : Thanks for the hint.
    I manged to get 5.6 working by copying the data dir contents from the 5.6 zip file to the laraval data\mysql dir


Log in to reply
 

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