title: MySQL federated host "my ip" is not allowed to connect mysql server
body: <p>I've confused about this problem, and still stuck out of it for a week.
  I've trying to federated table in mysql, but when tried to do query select to remote table. I got this message</p>
  
  <blockquote>
    <blockquote>
      <p>Error Code: 1429. Unable to connect to foreign data source: Host '172.25.97.136' is not allowed to connect to this MySQL server</p>
    </blockquote>
  </blockquote>
  
  <p>while 172.25.97.136 is my ip static address not remote server's ip address</p>
  
  <p>i've read this solution <a href="https://stackoverflow.com/questions/1559955/host-xxx-xx-xxx-xxx-is-not-allowed-to-connect-to-this-mysql-server">Host &#39;xxx.xx.xxx.xxx&#39; is not allowed to connect to this MySQL server</a> But still didn't work.</p>
  
  <p>anyone can help, please?</p>