title: mysql revoke root privileges carefully
body: <p>I accidentally did something a bit stupid and typed this into the mysql console:</p>
  
  <pre><code>mysql&gt; grant all on myDB.* to root@'%' identified by 'root';
  </code></pre>
  
  <p>... and the db configuration is open to remote logins. Now I need to remove this grant but don't want to accidentally revoke all privileges for my root user and effectively lock myself out of the db as the db admin. What should I do?</p>