mysql数据库连接vb.net

Question

我正在尝试连接到数据库，但它不起作用...

代码:

        Dim conn As MysqlConnection

    conn = New Mysqlconnection()
    conn.ConnectionString = "server=http://www.*****.net/phpMyAdmin; user id=*****; password=****; database=login"

    Try
        conn.Open()
    Catch myerror As MySqlException
        MsgBox("Error connecting to database!")
    End Try

它总是说连接数据库时出错!

有什么问题吗？

Answer 1

您不能使用http://www.*****.net/phpMyAdmin作为您的服务器名称。它应该只是您的域名(主机名)mydomain.com 或 IP 地址192.168.0.10

它应该如下所示:

Dim conn As MySqlConnection = New MySqlConnection
conn.ConnectionString = "Host=192.168.0.10;user=root;password=root"
conn.Open()