Ошибка sql 3948

I don’t understand the responses that others have provided to similar questions except for the most obvious ones, such as the one below:

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)

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.

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 the command line shell.

Недавно установленный mysql, впервые импортирующий 530 000 данных такого объема, легко сделать несколько ошибок:
1. Не забудьте изменить «» на «/» при вводе адреса файла источника данных.
2, легко сообщить об ошибке ОШИБКА 3948 (42000): загрузка локальных данных отключена; ее необходимо включить как на стороне клиента, так и на стороне сервера.

Решение такое:
Первый шаг *** Откройте окно команды mysql ***
Если mysql не установлен на диске c, сначала найдите адрес папки bin и откройте окно командной строки клиента mysql.

C:UsersRLBXCW>D:

D:>cd changemysql-8.0.19-winx64bin

D:changemysql-8.0.19-winx64bin>mysql --local-infile -u root -p

Появляется следующая картинка:

Второй шаг обнаружен, чтобы сообщить об ОШИБКЕ 3948 (42000):
означает, что разрешение на импорт локальных файлов не открыто, введите следующий код

mysql> show variables like 'local_infile';
mysql> set global local_infile=on;

Появляется следующая картинка:

Шаг 3. Используйте код для вставки источника данных

load data local infile'C:/Users/RLBXCW/Desktop/user_info_utf.csv' into table data.userinfo

fields terminated by ',';

заметка
‘C: /Users/RLBXCW/Desktop/user_info_utf.csv’ Это проверяет адрес отдельного файла, обратите внимание на ввод «/»
data.userinfo представляет имя изначально созданной таблицы, в соответствии с реальной ситуацией, другие части могут быть скопированы
Появится следующее изображение

С первых двух недель обучения я по-прежнему непобедимый профан, но жизни нет предела! доверяй себе!

I am working on a python project with MySQL connectivity. I have MySQL as a shell, i.e.,I need to use mysqlsh command in the Terminal to use MySQL(I am using MacOS Mojave 10.14.6). I needed to use a csv file to store data taken from user and then transfer it to a MySQL database. After doing some research, I found the best way to do it was by giving theLOAD DATA LOCAL INFILE command to my_c.execute()(‘my_c‘ is the cursor I defined to use for Python-MySQL connectivity) in Python. However when I run the command:
my_c.execute('LOAD DATA LOCAL INFILE "/test1Desktop/Python/Practice/body.csv" INTO TABLE POQ COLUMNS TERMINATED BY "," ESCAPED BY '"' LINES TERMINATED BY 'n'IGNORE 1 LINES')

I get the following errors:

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

During handling of the above exception, another exception occurred:

mysql.connector.errors.DatabaseError: LOAD DATA LOCAL INFILE file request rejected due to restrictions on access.

Here is a screenshot of the code:

As both the files(python and the source file) are in the same directory, I tried removing the full path of the file, and just writing the file name; but that didn’t work either.

#The password has been removed.

Here is the screenshot of the error output:

I tried researching the errors, and many suggested to use the command show global variables like 'local_infile'; and set global local_infile=true; in MySQL. Sure the value changed from NULL to ON. But there was still no difference.

#Some solutions suggested to make changes to the ‘my.cnf’ file. Bit when I tried to find it, I found that it doesn’t exist.
#Some suggested to make changes to secure-file-priv in the file file /etc/mysql/mysql.conf.d/mysqld.cnf. But this file was also not found.

Can someone pls tell what is wrong and how to fix it? Pls give step-by-step solution as I am not very good with the in-depth technical details of it.

Other information:

1. OS: MacOS Mojave(10.14.6)
2. Python version: 3.9.2
3. MySQL shell version: 8.0.23

If you need other information, do tell.