0

This is my connection class for C#, but it doesn't work:

class DB
{
    MySqlConnection connection;
    //Baglanti adında bir bağlantı oluşturdum

    public bool baglanti_kontrol()
    {
        connection = new MySqlConnection("Server=93.89.xx.xx:3306;Database=database_database;Uid=database_userid;Pwd='password';");
        connection.Open();
        return true;
    }
}

I tried to every solution in the same topic.

My server gives permission for my IP address.

I am getting the following exception:

'x.x.x.x' for user 'xx_xx' using method 'mysql_native_password' failed with message: Access denied for user 'xx_xx'@'x.x.x.x' (using password: YES)'

Batuhan Atalay
  • 11
  • 1
  • Is this a server accessed over the Internet? Note that connecting directly to database servers over a relatively high-latency (5ms+) connection is a bad idea because DB protocols are typically very chatty, which amplifies the effects of latency. – Dai May 21 '17 at 10:34
  • 1
    *"...but it doesn't work..."* <- in what way doesn't it work? Please elaborate on any errors you are receiving, what your expected outcome is and what your actual outcome is. Your question in its current state is rather unclear. – Geoff James May 21 '17 at 10:36
  • MySql.Data.MySqlClient.MySqlException: 'Unable to connect to any of the specified MySQL hosts.' @GeoffJames – Batuhan Atalay May 21 '17 at 10:59
  • @BatuhanAtalay - so, why don't you include this exception in your original question? :) – Geoff James May 21 '17 at 11:00
  • @GeoffJames I'm sorry for that. Can help to fix that problem ? – Batuhan Atalay May 21 '17 at 11:20
  • Possible duplicate of [Unable to connect to any of the specified mysql hosts. C# MySQL](http://stackoverflow.com/questions/17993657/unable-to-connect-to-any-of-the-specified-mysql-hosts-c-sharp-mysql) – Geoff James May 21 '17 at 11:21
  • @BatuhanAtalay - as the top answer on the possible duplicate I have posted suggests, it might be that your parameters are not spaced correctly. A useful site I use to ensure I format connection strings correctly is http://connectionstrings.com – Geoff James May 21 '17 at 11:23
  • @GeoffJames Now i get 'x.x.x.x' for user 'xx_xx' using method 'mysql_native_password' failed with message: Access denied for user 'xx_xx'@'x.x.x.x' (using password: YES)' – Batuhan Atalay May 21 '17 at 11:25
  • @BatuhanAtalay - Long shot - but your `password` in the sample code you have provided is in quotes. Is this a typo in your example, or are you using quotes in the actual code? This might be your issue. – Geoff James May 21 '17 at 11:30

1 Answers1

0

I solve the problem like this

"Server=93.89.xx.xx;Port=3306;Database=database_database;Uid=database_userid;Pwd=password;"

Problem is I didn't define "Port" and my password like 'password'

Batuhan Atalay
  • 11
  • 1