title: Disabling MySQL remote access to root
body: <p>I have a <em>MySQL Installation</em> which has recently been compromised. Unfortunately this was due to another person leaving the '<strong>root</strong>' account remotely accessible. I am currently trying to create an <em>admin account</em> which is locked down to specific IP Addresses and revoke the remote access on root.</p>
  
  <p>Problems:</p>
  
  <ul>
  <li>Custom admin account has specific IP Addresses set under "Host" but 
  currently is permitting connections from any IP Address.
  
  <ul>
  <li>Root user still allows remote logins despite Host being set to "127.0.0.1", "::1" and "localhost".</li>
  </ul></li>
  </ul>
  
  <p>I have flushed the privileges after making the changes shown in the following screenshot, where I am at a loss. Can anyone please let me know what I am doing wrong?</p>
  
  <p><a href="https://i.stack.imgur.com/n4tXx.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/n4tXx.png" alt="enter image description here"></a></p>