mysql ERROR 3948 (42000): Loading local data is disabled; this must be enabled on both the client and server sides

?

1 2 3 4 5 6 7

mysql> select version(); +-----------+ | version() | +-----------+ | 8.0.20    | +-----------+ 1 row in set (0.00 sec)

　　使用 load data 导入数据时候报错

解决办法

1.server端

?

1 2 3 4 5 6 7

mysql> show variables like '%local_infile%'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | local_infile  | ON    | +---------------+-------+ 1 row in set (0.01 sec)

2.client端

mysql --local-infile 登录服务端

?

1 2 3

mysql> load data local infile '/tmp/pet.text' into table pet; Query OK, 1 row affected (0.01 sec) Records: 1  Deleted: 0  Skipped: 0  Warnings: 0