title: ERROR: Loading local data is disabled - this must be enabled on both the client and server sides
body: <p>I don't understand the responses that others have provided to similar questions except for the most obvious ones, such as the one below:</p>
  
  <pre><code>mysql&gt; SET GLOBAL local_infile=1;
  Query OK, 0 rows affected (0.00 sec)
  
  mysql&gt; SHOW GLOBAL VARIABLES LIKE 'local_infile';
  
  +---------------+-------+
  | Variable_name | Value |
  +---------------+-------+
  | local_infile  | ON    |
  +---------------+-------+
  1 row in set (0.01 sec)
  </code></pre>
  
  <p>By this I mean the exact code was provided. I'd greatly appreciate if someone could walk me through, step by step, what I need to do to enable local data on the "client" side and "server" side. It seems like I've enabled local data on the client side, but I don't know what instructions I need to give my computer to enable the "server side". I'm not tech savvy at all, and I just want to be able to get to the point where the data has been uploaded into MySQL workbench.</p>
  
  <pre><code>ERROR 3948 (42000): Loading local data is disabled; this must be enabled on both the client and server sides
  </code></pre>
  
  
  
  <pre><code>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)
  ;
  </code></pre>
  
  <p>I just want to be able to import a .csv file into MySQL using the command line shell.</p>