Answer the question
In order to leave comments, you need to log in
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
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 ....
Answer the question
In order to leave comments, you need to log in
grant file on *.* to [email protected] identified by 'password';
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question