Laragon 4.0 with Mysql 5.7 and Mysql 5.6

[cosmosvega]

Hi all,

I installed laragon 4.0.12 with php 7.2 and mysql 5.7, all correct, however, I have also installed mysql 5.6 and when I start laragon I get the following message:

[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.

I noticed that both my.ini file of mysql 5.7 and that of mysql 5.6 are exactly as configured.

I'm going crazy with this topic...

thank you!

[leokhoa]

@cosmosvega : It is just the warning and you can update my.ini to set it if you want to dismiss the warning.
Ref: https://geodatawrangler.lazym8.com/blog/2017/02/16/secure-file-priv

[cosmosvega]

Hello again,

Mysql 5.6 does not start ... I attached a link with a screenshot.
See screenshot

Thank you!

[leokhoa]

@cosmosvega : Can you try:

1. Change the datadir value in MySQL 5.6 my.ini
2. If 1) doesn't work, just try creating another instance of Laragon.

[cosmosvega]

• The my.ini is identical in the two versions of mysql (Mysql 5.7 and 5.6) but in 5.6 the file my-default.ini is also included with this content:
  sql_mode = NO_ENGINE_SUBSTITUTION, STRICT_TRANS_TABLES

• I've tried running another laragon with mysql 5.6 but nothing ...

[leokhoa]

@cosmosvega : What do you mean nothing...?
Any images?

[fysioski]

I have same problem. Mysql 5.6 gives same error as @cosmosvega.

[cosmosvega]

@leokhoa said in Laragon 4.0 with Mysql 5.7 and Mysql 5.6:

What do you mean nothing...?
Any images?

I mean he does the same ... the same error message...

[leokhoa]

@fysioski , @cosmosvega : I fixed the issue with Laragon 4.0.13.
You can update the patch here:
https://github.com/leokhoa/laragon/blob/master/laragon.exe

[leokhoa]

@cosmosvega : Does it work for you?

[cosmosvega]

I have not tried it yet...

Thanks!!

[fysioski]

I have same problem and also reflects on 4.0.13. See screenshot:
https://webdoc.nl/wl/?id=xWz2iaVhrZ0FW1Pv7rfeunRIXWugsDs8

[leokhoa]

@cosmosvega : Any update?
@fysioski : Can you show me the mysql log?

[fysioski]

posted url of log in dm

[fysioski]

Hello @leokhoa we made a nice solution. Two versions of laragon if you want both mysl5.6 and 5.7. There is some issue on the datadir that cannot be overruled.

[tdchien]

Yes, that's right. I also have the same this problem.
We need create twos version of laragon if want to both mysql 5.6 and mysql 5.7

[ejaaz-di]

@leokhoa I also have same problem......
I tried this https://geodatawrangler.lazym8.com/blog/2017/02/16/secure-file-priv but this wont work for me

[ejaaz-di]

@leokhoa

see this

[leokhoa]

@ejaaz-di : It is just a WARNING message. You must open the mysql log file to see the root cause.

[ejaaz-di]

@leokhoa