R
R
Roman Fov2017-11-06 16:01:23
MySQL
Roman Fov, 2017-11-06 16:01:23

How to enable LOAD DATA LOCAL INFILE?

Hello!
I'm trying to upload csv to database.
The base responds that such an operation is prohibited.
In my.conf local-infile is included

[client]
......
local-infile=1

[mysqld]
......
local-infile = 1

In pdo the flag is enabled.
Here is what it gives out:
Exception: Query error 28000: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'user'@'localhost' (using password: YES). Query: LOAD DATA INFILE '/tmp/php6QoIk1' INTO TABLE ....

What could be the problem? Where to dig?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
Dmitry Shitskov, 2017-11-06
@Roman-Fov

grant file on *.* to [email protected] identified by 'password';

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question