title: MySql.Data.MySqlClient.MySqlException: There is no 'root'@'%' registered
body: <p>i run web application on iis 6 , windows server 2003 , mysql database.</p>
  
  <p>first it was working fine, but when i reconfigured the mysql server with the same password it gave me this message error when i want to enter any page in browser :</p>
  
  <pre><code>"MySql.Data.MySqlClient.MySqlException: There is no 'root'@'%' registered".
  </code></pre>
  
  <p>i checked the app connection it's the same, as though the app doesn't see the localhost , because "dbforge" sometimes give me this message: <code>"connection localhost cannot be found"</code> but when i doubleclick the connection it opens as root.</p>
  
  <p>any idea to solve this problem </p>
  
  <hr>
  
  <p>i solve it :</p>
  
  <p>to access mysql from any pc you'd have to issue the following command...</p>
  
  <p>GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY 'mysql' WITH GRANT OPTION;</p>