title: Unable to connect to MySQL server from VPS but able to from desktop
body: <p>I'm connecting to my MySQL server that is hosted remotely using the MySQL-connector package in python. I created a user for my home computer with my home IP address which works just fine and can connect without any issues whatsoever.</p>
  <p>But whenever I've tried to either:</p>
  <p>a). Create a new user, grant privileges and connect from a secondary VPS</p>
  <p>or</p>
  <p>b). Create a new user that is on the MySQL server VPS (localhost), granted privileges and then tried to connect to the MySQL server</p>
  <p>I've time over time encountered this error:</p>
  <pre><code>1045 (28000): Access denied for user 'username'@'localhost' (using password: YES)
  </code></pre>
  <p>(when I tried option a the IP would be my VPS's IP).</p>
  <p>I really have no clue how I would go about fixing this. My bind-address is set to 0.0.0.0 and my firewall is inactive/open to everyone on port 3306.</p>
  <p>If any of you got any suggestions on how I can fix this please let me know</p>