Mysql permission errors with ‘load data’

by

Here’s a thread on the MySQL forums that discusses exactly this.

Here’s the answer, posted by Ken Tassell

Problem resolved using the command below:

grant file on *.* to kentest@localhost identified by 'kentest1';

More Related Contents:

  1. access denied for load data infile in MySQL
  2. How do I import CSV file into a MySQL table?
  3. Import data in MySQL from a CSV file using LOAD DATA INFILE
  4. Access denied for user ‘root@localhost’ (using password:NO)
  5. MySQL load NULL values from CSV data
  6. MySQL: Access denied for user ‘test’@’localhost’ (using password: YES) except root user
  7. brew install mysql on macOS
  8. How can I restore the MySQL root user’s full privileges?
  9. How to import a CSV file into a MySQL table
  10. MySQL LOAD DATA INFILE with ON DUPLICATE KEY UPDATE
  11. How to reset mysql root password?
  12. MySQL – ERROR 1045 – Access denied
  13. Access denied for user ‘root’@’localhost’ while attempting to grant privileges. How do I grant privileges?
  14. Importing a csv into mysql via command line
  15. How to skip columns in CSV file when importing into MySQL table using LOAD DATA INFILE?
  16. Import CSV to MySQL
  17. LOAD DATA LOCAL INFILE gives the error The used command is not allowed with this MySQL version
  18. MYSQL into outfile “access denied” – but my user has “ALL” access.. and the folder is CHMOD 777
  19. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  20. MySQL load data infile – acceleration?
  21. how to delete data from table A besides the customer service and director data in table B?
  22. Get records with max value for each group of grouped SQL results
  23. MySQL: multiple tables or one table with many columns? [closed]
  24. Add 2 hours to current time in MySQL?
  25. How to get first day of every corresponding month in mysql?
  26. How can I change MariaDB to MySQL in XAMPP?
  27. MySQL: LIMIT by a percentage of the amount of records?
  28. Select a column with a keyword name
  29. ERROR 1356 (HY000): View ‘mysql.user’ references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
  30. Use Composite Primary Key as Foreign Key

Leave a Comment