title: MySQL - ODBC connect fails, Workbench connect works
body: <p>I am <strong>trying to install and test a MySQL ODBC Connector</strong> on my machine (Windows 7) to connect to a remote MySQL DB server, but, when I configure and test the connection, I keep getting the following error:</p>
  
  <pre><code>Connection Failed
  [MySQL][ODBC 5.3(w) Driver]Access denied for user 'root'@'(my host)' (using password: YES):
  </code></pre>
  
  <p>The problem is, <strong>I can connect with MySQL Workbench (remotely - from my local machine to the remote server) just fine.</strong> I have read <a href="http://dev.mysql.com/doc/refman/5.6/en/access-denied.html" rel="noreferrer">this FAQ</a> extensively but it's not helping out. I have tried:</p>
  
  <ul>
  <li>Checking if mysql is running on the server (it is. I even tried restarting it many times);</li>
  <li>Checking if the port is listening for connection on the remote server. It is.</li>
  <li>Connecting to the remote server using MySQL Workbench. It works.</li>
  <li>Checking if the IP address and Ports of the remote database are correct;</li>
  <li>Checking if the user (root) and password are correct;</li>
  <li>Re-entering the password on the ODBC config window;</li>
  <li>Checking and modifying the contents of the "my.conf" on the remote server to allow connections from all sides (0.0.0.0);</li>
  <li>Including (my host) on the GRANT HOST tables from mySQL (I also tried the wildcard '%' but it's the same as nothing);</li>
  <li>Running a FLUSH HOSTS; And FLUSH PRIVILEGES; command on the remote mySQL server to reset the privilege cache;</li>
  <li>Turning off my Firewall during the configuration of the ODBC driver;</li>
  <li>Checked if the MySQL variable 'skip_networking' is OFF in order to allow remote connections.</li>
  </ul>
  
  <p>What is frustrating is that I can connect with MySQL Workbench on my local machine (with the same IP/user/password), just not with ODBC.</p>
  
  <p>What could I be doing wrong, or what could be messing up my attempt to connect with ODBC?</p>
  
  <p><strong>Update</strong>: I managed to set up the ODBC driver and get it running correctly on the server side. I can connect there to the localhost using a command line (with the "isql" command). But I still can't connect over remotely with my Windows 7 machine. </p>