I don't understand other people's answers to similar questions, except for the most obvious ones, like the following:

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)

I mean the exact code is provided. I would be grateful if someone could walk me through what I need to do to enable local data on both the "client" side and the "server" side. It seems that I have local data enabled on the client side, but I don't know what instructions I need to give my computer to enable "server side". I'm not tech savvy at all, I just want to be able to upload data to 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, product_name, manufacturer, price, number_available_in_stock, number_of_reviews, number_of_answered_questions, average_review_rating, amazon_category_and_sub_category, customers_who_bought_this_item_also_bought, description, product_information, product_description, items_customers_buy_after_viewing_this_item, customer_questions_and_answers, customer_reviews , sellers) ;

I just want to be able to import a .csv file into MySQL using a command line shell.