title: Connecting to MySQL from remote host using wildcards not working
body: <p>Hi so I am trying to set up my mysql server to accept remote connections from all hostnames by using a % sign in the place of hostname. This however still will not let me connect. My MySQL user table is as follows:</p>
  
  <p>mysql> select host,user from user;</p>
  
  <pre><code>+----------------+------------------+
  | host           | user             |
  +----------------+------------------+
  | %              | guest            |
  | 127.0.0.1      | root             |
  | 197.87.180.*** | guest            |
  | ::1            | root             |
  | localhost      |                  |
  | localhost      | debian-sys-maint |
  | localhost      | root             |
  | raspberrypi    |                  |
  | raspberrypi    | root             |
  +----------------+------------------+
  </code></pre>
  
  <p>I am able to connect to the server using the username guest from my remote computer with IP address 197.87.180.* but any other IP it gives me the error <strong>Access denied for user 'guest'@'197.87.<em></strong>.<strong></em>' (using password: YES)</strong></p>
  
  <p>Anyone know the reason for this or what I am doing wrong?</p>