title: Database connection troubleshooting
body: <p>I recently picked up C# programming and am hoping to read in tables from mySQL tables and display them in DataGridView controls. The tables are generated using PHP scripts and I am able to login to my database. In PHP I am using the following connection string:</p>
  
  <p>@mysql_connect('localhost:3307','root','password_string');</p>
  
  <p>In C#, I am using the following connection string:</p>
  
  <p>string MyConString = @"Server=localhost;Database=database_name;User ID=root;Password=password_string";</p>
  
  <p>When I run the program, I get the following message in the console:</p>
  
  <p>"Access denied for user 'root'@'localhost' "</p>
  
  <p>I've tried making countless changes to the connection string by using single quotes, using localhost:3307, etc. I've granted privileges for user root, so I don't think that is the issue. How do I get past this? Is there some problem with the connector I have. Any ideas would be much appreciated. </p>