title: How do I manually block and then unblock a specific IP/Hostname in MYSQL
body: <p>First off, I did google this but sites are flooded with advice on how to deal with "host name is blocked" issues. (<a href="https://www.google.com/search?q=mysql+block+a+host" rel="nofollow">https://www.google.com/search?q=mysql+block+a+host</a>). My issue is a little bit the opposite of that.</p>
  
  <p>With me, I am running a MySQL database and no PHP is involved.</p>
  
  <p>I need to block a certain host-name/IP address from connecting to my database, then I will unblock it. I am hoping there are 2 simple queries for this that I can execute on the MySQL database, I just can't seem to find it anywhere.</p>
  
  <p>I can find the hostnames pretty easily by running the <code>show processlist</code> query and I know I can kill one process at a time, but so many new threads pop up that if I can just block all of them from a certain hostname, that would be ideal. Then I will unblock once I fix a few things. </p>