title: How to grant remote access to MySQL for a whole subnet?
body: <p>I can easily grant access to one IP using this code:</p>
  
  <pre><code>$ mysql -u root -p
  Enter password:    
  mysql&gt; use mysql    
  mysql&gt; GRANT ALL ON *.* to root@'192.168.1.4' IDENTIFIED BY 'your-root-password';     
  mysql&gt; FLUSH PRIVILEGES;
  </code></pre>
  
  <p>But i need to allow the whole subnet 192.168.1.* to access the database remotely.</p>
  
  <p>How can i do that? </p>