mysqlimport: Error: 1227 Access denied with MySQL 8.0 and Amazon RDS

Question

We are using MySQL 8.0.* and .csv file for the importing data into Amazon RDS. We are executing this command from the app server command line.

Error:

mysqlimport: Error: 1227 Access denied; you need (at least one of) the SUPER, SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privilege(s) for this operation

Command:

mysqlimport --local --compress --columns='col1,col2,col3,col4' -h dbhost -u dbusername -pdbpassword dbname --fields-terminated-by='|' file_path/table_name.csv

We have already provided DBA permission to DB user.

Answer 1

As error suggests, the user you are running import command not having permissions SESSION_VARIABLES_ADMIN.

You could setup it like below.

GRANT SESSION_VARIABLES_ADMIN ON *.* TO 'user'@'%';

OR

GRANT SESSION_VARIABLES_ADMIN ON *.* TO 'user'@'specific-host';

It should resolve the issue.