How to add MySQL 5.5 / 5.6
-
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?
-
@ZeroMD
You can try deleting theC:\laragon\data\mysqldir and then re-initialize MySQL 5.6 on that dir.
-
@leokhoa said in How to add MySQL 5.5 / 5.6:
@ZeroMD
You can try deleting theC:\laragon\data\mysqldir 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/
-
@ZeroMD : You may try download Laragon portable:
https://sourceforge.net/projects/laragon/files/Portable/laragon-3.1.7zExtract it and copy the data dir to the location.
-
@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
303 points