title: Can't Connect to Remote MySQL Database
body: <p>I am trying to connect to a MySQL database on my server. Here is my small sample that I am using to connect:</p>
  
  <pre>
  <code>
  using System;
  using System.Data;
  using MySql.Data.MySqlClient;
  
  namespace MySqlTest
  {
      class MainClass
      {
          public static void Main (string[] args)
          {
          string connectionString =
            "Server=12.34.546.213;" +
            "Database=Test;" +
            "UID=root;" +
            "Password=password;";
         IDbConnection dbcon;
         dbcon = new MySqlConnection(connectionString);
         dbcon.Open();
  </code>
  </pre>
  
  <p>I get the following error when I try to execute this code:</p>
  
  <pre>
  
  Unhandled Exception: MySql.Data.MySqlClient.MySqlException: Access denied for us
  er 'root'@'12.34.546.213' (using password: YES)
     at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
     at MySql.Data.MySqlClient.NativeDriver.AuthenticateNew()
     at MySql.Data.MySqlClient.NativeDriver.Authenticate()
     at MySql.Data.MySqlClient.NativeDriver.Open()
     at MySql.Data.MySqlClient.Driver.Open()
     at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings
  )
     at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
     at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
     at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
     at MySql.Data.MySqlClient.MySqlPool.GetConnection()
     at MySql.Data.MySqlClient.MySqlConnection.Open()
     at MySqlTest.MainClass.Main(String[] args) in c:\Users\dvargo\Documents\Proje
  cts\MySqlTest\MySqlTest\Main.cs:line 18
  Press any key to continue . . .
  </pre>
  
  <p>Any ideas why this might be? How can I give permissions to root so I can access it?</p>