stajichlab / OrthoMCL

24 stars 11 forks source link

Having problem at the step 8 with mysql-8.0.11 #7

Open juulluu21 opened 6 years ago

juulluu21 commented 6 years ago

I am trying to use OrthoMCL. Having problem at the step 8. I am getting this message over and over again.

DBD::mysql::st execute failed: The used command is not allowed with this MySQL version at .......orthomclSoftware-v2.0.9/bin/orthomclLoadBlast line 39, line 14.

My command was: ...bin/orthomclLoadBlast .....orthomclSoftware-v2.0.9/my_orthomcl_dir/orthomcl.config.template ....orthomclSoftware-v2.0.9/my_orthomcl_dir/compliantFasta/similarSequences

I have installed mysql-8.0.11-macos10.13-x86_64.dmg in MacOS High Sierra 10.13.6

I have tried to add: dbConnectString=dbi:mysql:orthomcl:mysql_local_infile=1 to my orthomcl.config.template file. Still not working.

Is it happening because of the mysql_local_infile=1 issue? I am not sure if it is differently used in mysql-8.0.11.

Please help me. Thanks.