Can't use mysqlimport since MySQL 8 upgrade due to insufficient privileges

Question

Since upgrading my RDS instance to MySQL 8 I am no longer able to use mysqlimport to import external data from .csv files. When running mysqlimport it returns the following 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`

It is, however, impossible to assign any of these privileges. The [RDS User Guide instructions for mysqlimport](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Importing.AnySource.html) provide instructions for setting the SESSION_VARIABLES_ADMIN privilege for MySQL version 8.0.15 and higher by running the

`GRANT SESSION_VARIABLES_ADMIN ON *.* TO *user*;`

command, but this results in the following error:

`ERROR 1227 (42000): Access denied; you need (at least one of) the GRANT OPTION privilege(s) for this operation`
... and RDS does not support the GRANT OPTION privilege.

Answer

Hello.

Please use the following command to set the privilege "ROLE_ADMIN" to the database administrative user (such as the root user), and then try setting "SESSION_VARIABLES_ADMIN".  
```
GRANT ROLE_ADMIN on *.* to root
```

Can't use mysqlimport since MySQL 8 upgrade due to insufficient privileges

Relevant content