我不明白其他人對類似問題的回答，除了最明顯的問題，例如下面的問題：

mysql> SET GLOBAL local_infile=1; 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.01 sec)

我的意思是提供了確切的程式碼。如果有人能夠逐步引導我了解我需要做什麼才能在「客戶端」端和「伺服器」端啟用本地數據，我將不勝感激。似乎我已經在客戶端啟用了本地數據，但我不知道需要給我的電腦什麼指令才能啟用「伺服器端」。我根本不懂技術，我只想能夠將資料上傳到 MySQL Workbench。

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

CREATE TABLE toys ( uniq_id VARCHAR(1000), product_name VARCHAR(1000), manufacturer VARCHAR(1000), price VARCHAR(1000), number_available_in_stock VARCHAR (1000), number_of_reviews INT, number_of_answered_questions INT, average_review_rating VARCHAR(1000), amazon_category_and_sub_category VARCHAR(1000), customers_who_bought_this_item_also_bought VARCHAR(1000), description VARCHAR(1000), product_information VARCHAR(1000), product_description VARCHAR(1000), items_customers_buy_after_viewing_this_item VARCHAR(1000), customer_questions_and_answers VARCHAR(1000), customer_reviews VARCHAR(1000), sellers VARCHAR(1000) ); LOAD DATA LOCAL INFILE ‘/Users/BruddaDave/Desktop/amazonsample.csv’ INTO TABLE toys FIELDS TERMINATED BY ‘,’ LINES TERMINATED BY ‘n’ IGNORE 1 LINES (uniq_id, 非items_customers_buy_after_viewing_this_item, customer_questions_and_answers, customer_reviews, sellers) ;

我只是希望能夠使用命令列 shell 將 .csv 檔案匯入 MySQL。