Giving SUPER Privileges to remote user
Posted by: Samet Şahin
Date: January 10, 2020 01:12AM

I have a MySQL database in the server. I'd like to insert some data that I have in .csv format. After connecting to remote database, I try to execute below SQL statement.

LOAD DATA LOCAL INFILE '~/Downloads/words.csv'
INTO TABLE word
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS;
Result is the error:

The used command is not allowed with this MySQL version

After doing some research, I understood that I have to enable local-infile to be able import csv to table. In order to set local-infile to 1, I execute this statement:

SET GLOBAL local_infile = 1;
Result is the error:

ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER privilege(s) for this operation

And when I try to grant all permissions to remote user with below statement

GRANT ALL PRIVILEGES ON *.* TO username@host;
I get,

You are not allowed to create a user with GRANT

even to I'm logged in as root. What do I need to do?

Options: ReplyQuote


Subject
Written By
Posted
Giving SUPER Privileges to remote user
January 10, 2020 01:12AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.