title: Re-assign host access permission to MySQL user
body: <p>I have several thousand MySQL users all set to allow access from a specific host. The problem is that now I'm going to have two machines (more in the future) which will need to use the same account to access each of their databases.</p>
  
  <p>I'd like a quick and easy (as automated as possible) way to run through and modify the host portion of each user account to fit an internal network wildcard. For example:</p>
  
  <blockquote>
    <p>'bugsy'@'internalfoo' has access to the 'bugsy' DB.</p>
  </blockquote>
  
  <p>I want to now allow bugsy access from anywhere on the internal network</p>
  
  <blockquote>
    <p>'bugsy'@'10.0.0.%' has access to the 'bugsy' DB.</p>
  </blockquote>