title: Users can't connect remotely to MySQL
body: <p><strong>Problem</strong></p>
  
  <p>Users from other IPs on the (Windows XP) LAN suddenly cannot connect to my local MySQL server.</p>
  
  <p><strong>Background</strong></p>
  
  <p>I've set up MySQL on my local Windows computer so that other computers on the network have access to the root account. I've added each IP as a host for root. Up to some weeks ago, things worked flawlessly and I could connect to the server programatically and using various MySQL admin tools. Now, however, the MySQL server simply refuses connections from those IPs and I can't figure out why. </p>
  
  <p>The network changes that I've done are: changing network card for two (of three) computers and fiddled around with MySQL settings. None of which should have caused this problem. I've tried adding a new user with all relevant hosts, but I get the same type of error: </p>
  
  <blockquote>
    <p>MySQL Error number 1045 Access denied
    for user 'root'@'shop' (using
    passwords: YES)</p>
  </blockquote>
  
  <p>The odd part is that the computer name, 'shop', is used instead of the IP. I don't know why.</p>