title: MySQL is not resolving IP address, but nslookup does resolve
body: <p>At work, my team have a MySQL database on a Linux 14.04 box. My team is working on changing the permissions to use hostnames rather than IPs (so that the IT team can do what they want to the network and not worry about breaking our access).</p>
  
  <p>For example, there would be a user <code>admin@10.10.xxx.xxx</code> that we will want to change to <code>admin@my-ws.co.local</code>. I've been playing around with my user (since I have root and can still log in). After changing the user profile's host from the IP address to the Hostname, Workbench will give the error...</p>
  
  <p><code>HOST '10.10.xxx.xxx' is not allowed to connect to this MySQL server</code></p>
  
  <p>When I log in to the Linux box and use <code>nslookup my-ws.co.local</code>, the response gives me the correct IP address, so I know there no connection issue between the box and the network. And since the response is correct, I am <em>assuming</em> that the internal DNS is working correctly.</p>
  
  <p>Checking the <code>performance_schema.host_cache</code> table, I can see that the IP <code>10.10.xxx.xxx</code> was not resolved into a host (the <code>HOST</code> column is <code>NULL</code> and the <code>HOST_VALIDATED</code> column is <code>YES</code>).</p>
  
  <p><strong>Why is MySQL unable to resolve the IP address into the correct hostname, while <code>nslookup</code> works?</strong> Is there some setting in MySQL that I need to fix? Do there need to be records in the internal DNS for each workstation of my team?</p>