title: How do I create a MySQL user with a wildcard domain?
body: <p>I am trying to setup a MySQL server that can be accessed by anyone on our internet network.</p>
  
  <p>I can connect, via PHP, to the server using localhost, but not with my IP as hostname:</p>
  
  <pre><code>Warning: mysqli::mysqli() [mysqli.mysqli]: (28000/1045): Access denied for user 'user'@'user.corp.companyname.com' (using password: YES) in /Library/WebServer/Documents/doc.php on line 38
  </code></pre>
  
  <p>I've setup the same MySQL user using the hosts localhost, %, and *, but MySQL still doesn't seem to accept unknown hosts.</p>
  
  <p><strong>Update</strong></p>
  
  <p>Well, I give up: other machines on the network seem to have no problem making the MySQL connection, so it's just my local machine that refuses to authenticate when using my IP as the host.</p>