远程connet mysql数据库 [英] connet mysql database remotely

问题描述

我想从我的计算机连接远程服务器上托管的mysql数据库。我应该为它做什么代码？ PLZ回复任何人。

i want to connect mysql database hosted on remote server from my computer. what code should i do for it? plz reply anyone.

推荐答案

试试这个代码

try this code

#region Using directives 


using System; 
using System.Data; 
using System.Data.SqlClient; 

#endregion 

namespace testConnect1 
{ 
class SqlTest1 
{ 
static void Main() 
{ 
string connectionString = "server=localhost;database=test;uid=denis;pwd=dhoctor"; 

SqlConnection mySqlConnection = new SqlConnection(connectionString); 

string selectString = "SELECT field01, field02, field03 " + "FROM test "; 

SqlCommand mySqlCommand = mySqlConnection.CreateCommand(); 

mySqlCommand.CommandText = selectString; 

SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter(); 

mySqlDataAdapter.SelectCommand = mySqlCommand; 

DataSet myDataSet = new DataSet(); 

mySqlConnection.Open(); 

Console.WriteLine("Retrieving rows from the Test table"); 
string dataTableName = "Test"; 
mySqlDataAdapter.Fill(myDataSet, dataTableName); 

DataTable myDataTable = myDataSet.Tables[dataTableName]; 

foreach (DataRow myDataRow in myDataTable.Rows) 
{ 
Console.WriteLine("Field01 = " + myDataRow["field01"]); 
Console.WriteLine("Field02 = " + myDataRow["field02"]); 
Console.WriteLine("Field03 = " + myDataRow["field03"]); 
} 

mySqlConnection.Close(); 
} 
} 
}

浏览以下链接



http://stackoverflow.com/questions/8935806/connect-with-remote-mysql -database [ ^ ]





http://www.rackspace.com/knowledge_center/article/mysql-connect-to-your-database-remotely [ ^ ]

Go through following links

http://stackoverflow.com/questions/8935806/connect-with-remote-mysql-database[^]


http://www.rackspace.com/knowledge_center/article/mysql-connect-to-your-database-remotely[^]

这篇关于远程connet mysql数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！