title: MySQL - How to grant access to only one of n slaves?
body: <p>I have one master and two slaves.</p>
  
  <p>Is it possible to restrict a particular read-only user to query only against the second slave (disallowing him from running any queries on the master and the first slave)?</p>
  
  <p>I see that one can do the following to make un-replicated changes to the master, but what I think I need is to make changes to one slave and not the other.</p>
  
  <pre><code>SET sql_log_bin = {OFF|ON}
  </code></pre>
  
  <p>And the GRANT syntax allows one to limit what host users come from, but -- as far as I understand -- not which DB server(s) the person can use.</p>
  
  <p>I didn't find much in a web search -- perhaps that's a hint that there's a better way to solve this problem. Basically I'm asking if this can be enforced by the database since the restriction I want applies to just this one user.</p>