I am trying to rename the root username to something else, I am using the following code, however, I get an error :( 

RENAME USER 'root'@'localhost' TO 'chosenName'@'localhost';

I get the following error ...

ERROR 1396 (HY000) : Operation RENAME USER failed for 'root'@'localhost'
mysql
Edit
Report