c# - 连接到我的数据库时出错（MySQL、C#）

Question

这在我运行程序时不起作用！

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;
            }
        }
    }
}

但它不工作！

错误：不允许主机“xxx”连接到这个 MariaDB 服务器！

标签： c#mysql

Answer 1

strConnection初始化连接时，不使用连接字符串属性。尝试：

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