How to deal with the error of JDBC connection MySQL that cannot use load data?

Alibaba cloud Q & A 2022-02-13 06:46:14 阅读数:19

deal error jdbc connection mysql

jdbc Connect mysql Can't use load data

Report errors The used command is not allowed with this MySQL version,local_infile yes true

Direct use mysql The remote invocation , No problem .

Take the answer 1:

Hello! ,jdbc url You need to add a parameter ,allowLoadLocalInfile=true, normal navicat Can run ,jdbc Need to add .

copyright:author[Alibaba cloud Q & A],Please bring the original link to reprint, thank you.