服務器版本:

Server version: 8.0.20-0ubuntu0.19.10.1 (Ubuntu)

完整報錯如下:

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

解決方案如下:

①客戶端設置

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> SHOW GLOBAL VARIABLES LIKE 'local_infile';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| local_infile ?| OFF ? |
+---------------+-------+
1 row in set (0.04 sec)

mysql> SET GLOBAL local_infile = true;
Query OK, 0 rows affected (0.00 sec)

mysql> SHOW GLOBAL VARIABLES LIKE 'local_infile';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| local_infile ?| ON ? ?|
+---------------+-------+
1 row in set (0.00 sec)

②服務端設置

mysql.conf.d/mysqld.cnf的[mysqld]下面添加local-infile

conf.d/mysql.cnf的[mysql]下面添加local-infile
mysql.conf.d/mysql.cnf的[mysql]下面添加local-infile

重啟mysql服務端

－－－－－－－－－－－－－

上述①②需要全部配置才能起到作用。

總結

以上是生活随笔為你收集整理的ERROR 3948 (42000): Loading local data is disabled问题解决的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。