mysql - 检查连接时无法连接到任何指定的 MySQL 主机

Question

我正在尝试通过 vb.net 连接到 Mysql 数据库但是我遇到了错误:

Unable to connect to any of the specified MySQL hosts

这是代码:

    Imports MySql.Data.MySqlClient
Public Class DBProject_1
    Dim MysqlConn As MySqlConnection

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
    MysqlConn = New MySqlConnection
    MysqlConn.ConnectionString = "server=localhost;userid=root;password=root;database=My_Mysql_Database"
    Try
        MysqlConn.Open()
        MessageBox.Show("Connection Successful")
        MysqlConn.Close()
    Catch ex As Exception
        MessageBox.Show(ex.Message)
    Finally
        MysqlConn.Dispose()

    End Try
End Sub
End Class

我什至尝试过使用

MysqlConn.ConnectionString = "server=**127.0.0.1**;userid=root;password=root;database=My_Mysql_Database"

可能是这个原因:当我在 Mysql Workbench 中测试 Mysql 数据库的连接时，测试失败。错误是 Failed to Connect to Mysql at 127.0.0.1:3306 with user root

Answer 1

试试这个 ConnectionString:

 MysqlConn.ConnectionString = "Server=localhost;Database=My_Mysql_Database;Uid=root;Pwd=root;"