title: Using 127.0.0.1 fails when connecting to MySQL while using IP succeeds using VB.net
body: <p>When trying to connect to MySQL using 127.0.0.1, using vb.net I get the following error message:</p>
  
  <p>"Authentication to host '127.0.0.1' for user 'test' using method 'mysql_native_password' failed with message: Access denied for user 'test'@'localhost' (Using Password:YES)"</p>
  
  <p>However when I replace 127.0.0.1 with the IP address for the same machine, the connection works perfectly fine.</p>
  
  <p>So what setting need to be changed to solve this issue so that I could use 127.0.0.1?</p>
  
  <p>Thanks in advance.</p>