title: Rename Root @ local host username mySQL
body: <p>I am trying to rename the root username to something else, I am using the following code, however, I get an error :( </p>
  
  <pre><code>RENAME USER 'root'@'localhost' TO 'chosenName'@'localhost';
  </code></pre>
  
  <p>I get the following error ...</p>
  
  <pre><code>ERROR 1396 (HY000) : Operation RENAME USER failed for 'root'@'localhost'
  </code></pre>