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.