如何连接MySQL

Question

vs2005通过LAN连接另一台主机:192.168.1.2
数据库名是:x
用户名是:root
密码是:1

Answer 1

下载安装 MYSQL的 .NET connector或者直接引用那个 MySql.Data.dll 也可以。

Answer 2

.....
using MySql.Data.MySqlClient;
.....            string sMySQLConnStr = "Database='test';Data Source='192.168.1.2';User Id='root';Password='1234567'";
            MySqlConnection mysqlCnn = new MySqlConnection(sMySQLConnStr);

Answer 3

C:\Documents and Settings\shihh>mysql -h192.168.8.29 -uroot -p1
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.1.36-community MySQL Community Server (GPL)Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql>
----------------------------------------------
红色部分即为要连的数据库 换作你的如下：
mysql -h192.168.1.2 -uroot -p1 
回车后 
mysql ->use x

Answer 4

运行mysql.exe
-h 192.168.1.2 -u root -p
下面就是提醒输入密码  

Answer 5

给你一个极简单的例子吧：
        static void testDataAdapter()
        {
            try
            {
                MySqlClientFactory factory = MySqlClientFactory.Instance;
                DbConnection conn = factory.CreateConnection();
                conn.ConnectionString = string.Format("server={0};user id={1}; password={2}; database={3}; port={4}; pooling=false",
                            "192.168.1.2", "root", "<passwd>", "x", 3306);
                conn.Open();                DbDataAdapter da = factory.CreateDataAdapter();                da.SelectCommand = conn.CreateCommand();
                da.SelectCommand.CommandText = "select * from t12345";
                da.DeleteCommand = conn.CreateCommand();
                da.DeleteCommand.CommandText = "delete from t12345 where id = @id";                DbParameter param = factory.CreateParameter();
                param.ParameterName = "@id";
                param.DbType = DbType.Int32;
                param.SourceColumn = "id";
                param.SourceVersion = DataRowVersion.Current;                da.DeleteCommand.Parameters.Add(param);
                da.DeleteCommand.UpdatedRowSource = UpdateRowSource.None;                DataTable dt = new DataTable("t12345");
                da.Fill(dt);                int index = 0;
                foreach ( DataRow o in dt.Rows )
                {
                    if (o["id"].Equals(4))
                    {
                        Console.WriteLine(String.Format("index={0}, to delete id = 4, col2 = {1}" , index, o["col2"]));
                        break;
                    }
                    index++;
                }
                dt.Rows[index].Delete();
                da.Update(dt);
                dt.AcceptChanges();                da.Dispose();
                conn.Close();
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Source + "\n"
                    + ex.Message + "\n"
                    + ex.StackTrace);
            }
            
        }
        
        static void Main(string[] args)
        {
            testDataAdapter();
        }
    }

Answer 6

 我用的odbc驱动，给你段vb6代码：
Dim conn As ADODB.Connection
        Dim rs As ADODB.Recordset
        Dim strprovider As String
        Dim strdatasource As String
        Dim strdatabasename As String
        Dim strconn As String
        strconn = "driver={MySQL ODBC 3.51 Driver};server=" & ServerIp & ";database=db1;uid=root;pwd=sa"
        Set conn = New ADODB.Connection
        conn.Open strconn
        Set rs = New ADODB.Recordset
        rs.CursorType = adOpenStatic '设置记录集的属性
       rs.CursorLocation = adUseClient
       rs.LockType = adLockPessimistic
       rs.Source = "select * from user where username='" & text1.text& "'"
       rs.ActiveConnection = conn
       rs.Open
       rs.Fields(0) = Text1.Text
       rs.Update