1 réponse
- Le plus récent
- Le plus de votes
- La plupart des commentaires
0
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
Contenus pertinents
- demandé il y a 2 mois
- demandé il y a un an
- AWS OFFICIELA mis à jour il y a 2 ans
- AWS OFFICIELA mis à jour il y a 4 mois
- AWS OFFICIELA mis à jour il y a 2 ans
While this ROLE_ADMIN command succeeds when running it under the admin user, subsequently trying to set the SESSION_VARIABLES_ADMIN privilege results in the same error as above: "ERROR 1227 (42000): Access denied; you need (at least one of) the GRANT OPTION privilege(s) for this operation".
By the way, is the database user used by "mysqlimport" the correct database administrator user (root user, etc.)?
Yes, I've tried running these commands with both the admin user and a separate user both of which I've tried assigning the appropriate privileges without success. I even reset the admin user password in the RDS console - which resets its privileges to the default.