title: MySQL Connector won't open
body: <p>I have what should be a trivial test here that is stubbornly refusing to work. On "Open" an exception "Unable to connect to any of the specified MySQL hosts" is thrown.</p>
  
  <p>MySQL.Data is Version 6.4.4.0 and is referenced in my visual studio project, which builds without errors. MySQL is V 5.5.16. The test is built using Visual Studio 2008 with Windows Forms and and is launched via a Button,</p>
  
  <p>I have tried this both under Windows XP and Windows 7, on different boxes. I gather from 
  <a href="http://dev.mysql.com/doc/refman/5.0/en/connector-net-connection-options.html" rel="nofollow"> the documentation </a> that it is permissible to use PASSWORD, PWD, UID, User Name, UserName, SERVER, HOST, and numerous variations on the keywords in the connection string, and I have tried them all with equal lack of success. </p>
  
  <p>I am confident that my username, password, and host name are correct. I am able to connect to my local MySQL DB via the command line using the same username and password. </p>
  
  <pre><code>using MySql.Data.MySqlClient;
  // and the ususal MS stuff...
       private void ToMySQL()
              {                
                  MySqlConnection myCon = new MySqlConnection("DataSource=Localhost;Username=root;Password=xxxx;database=data_xxx");        
                  try
                  {
                      myCon.Open();
                      MessageBox.Show("OK");
                  }
                  catch (Exception ex)
                  {
                      MessageBox.Show(ex.Message);
                  }
              }
  </code></pre>
  
  <p>These things usually turn out to be something totally trivial, but if so it's so trivial that it's invisible to me.</p>
  
  <p>What have I missed?</p>
  
  <p>Edit-Addendum: Answers so far have with one exception (npi) duplicated what fails. If the problem is environmental, where might I look?</p>