Rename Root @ local host username mySQL

Question

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'

Answer 1

Try this

UPDATE mysql.user set user = <newrootname> where user = 'root';
FLUSH privileges;

Answer 2

try this it will definitely work but only just make sure no mistake in syntax

mysql> use mysql;
mysql> update user set user="new_user" where user="root";
mysql> flush privileges;