I have something like this in phpmyadmin
so I need to add the FILE privelege so that I can get the data dump through console, I am logged in as root.Through PHPmyadmin if i click on Edit privileges and then select FILE and save it says
Even through console I tried this
GRANT SUPER ON *.* TO root@DBSERVERNAME IDENTIFIED BY abc2013;
and it says
ERROR 1470 (HY000): String 'root@DBSERVERNAME' is too long for user name (should be no longer than 16)
Not sure what I am missing,I only have access as root user.
To enable management and prevent users from breaking some of the management systems within RDS. You are restricted from access certain permissions (FILE and SUPER are not given to users).
FILE permissions wouldn't make sense anyway since you don't have local access to the RDS instance to load files in the first place.