Error to connecting to my database (MySQL, C#)

Question

This did not worked when I ran the program!

using MySql.Data; using MySql.Data.MySqlClient; namespace MySQL { class SqlConnection { public SqlConnection() { } ~SqlConnection() { } private string strConnection = "Server=localhost;Database=database;Port=3306;User ID=root;Password="; private MySqlConnection connection; public void OpenConnection() { connection = new MySqlConnection(); connection.Open(); } public void CloseConnection() { connection.Close(); connection.Dispose(); } public string StrConnection { set { StrConnection = value; } get { return StrConnection; } } } }

but it is not working!

ERROR : host 'xxx' is not allowed to connect to this MariaDB sever!

apomene · Accepted Answer · 2018-11-27 16:03:36Z

You don't use the connection string property strConnection, when you initialize your connection. Try:

public void OpenConnection() { connection = new MySqlConnection(strConnection); connection.Open(); }

Collectives™ on Stack Overflow

Error to connecting to my database (MySQL, C#)

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related