title: Connect to ONLINE MySQL database using DSN ODBC
body: <p>I am connecting an online MySQL database. </p>
  
  <p>I have downloaded MySQL ODBC Connector 5.1. Now am trying to setup the DSN. But am getting the error:</p>
  
  <pre><code>Connection Failed : [HY000] [MySQL] [ODBC 5.1 Driver]Access Denied for user 'user123'@'myweb.com' 
  </code></pre>
  
  <p>I have hosted this site with some hosting provider. Do i need some details from the provider????</p>
  
  <p>I am doing this > Control Panel--->Administrative Tools--->Data Sources (ODBC)--->Then i chose MySQL ODBC Driver 5.1-----> then i enter the following in the DIALOG which pops-up:</p>
  
  <p><strong>TCP/IP Server</strong>  - www.myweb.com 
  <strong>Port =3306</strong></p>
  
  <p><strong>userid=user123 and password</strong> , I enter those userid=user123 &amp; password which i enter when i open www.myweb.com/cpanel.</p>