c#如何连接网络mysql数据库
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
using MySql.Data.MySqlClient;
namespace WindowsFormsApp2
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
string strConnection = "Data Source=221.241.139.40:3306;Initial Catalog=xunixuni;uid=xunixuni;pwd=xxx1www2";
bool CanConnectDB = false;
using (MySqlConnection objConnection = new MySqlConnection(strConnection))
{
try
{
objConnection.Open();
CanConnectDB = true;
objConnection.Close();
}
catch { }
if (CanConnectDB) MessageBox.Show("数据库连接成功!", "提示:");
else MessageBox.Show("数据库连接失败!", "提示:");
}
}
}
}
以上IP、数据库名、用户名、密码是乱写的,但实际用了正确的,也一直提示连接失败,请教是哪里的问题?