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:
|
1 2 |
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:
|
1 2 |
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:
As error suggests, the user you are running import command not having permissions SESSION_VARIABLES_ADMIN.
You could setup it like below.
|
1 2 |
GRANT SESSION_VARIABLES_ADMIN ON *.* TO 'user'@'%'; |
OR
|
1 2 |
GRANT SESSION_VARIABLES_ADMIN ON *.* TO 'user'@'specific-host'; |
It should resolve the issue.