vb 如何连接mysql

Imports System.Data.OleDb

Module Module1
    Sub Main()
        Dim connectionString As String = "Provider=MSDASQL;Driver={MySQL ODBC 8.0 Unicode Driver};Server=your_server;Database=your_database;Uid=your_username;Pwd=your_password;"
        Dim connection As New OleDbConnection(connectionString)
        
        Try
            connection.Open()
            Console.WriteLine("Connected to MySQL database successfully!")
            
            Dim command As New OleDbCommand("SELECT * FROM your_table", connection)
            Dim reader As OleDbDataReader = command.ExecuteReader()
            
            While reader.Read()
                Console.WriteLine(reader("column_name"))
            End While
            
            reader.Close()
        Catch ex As Exception
            Console.WriteLine("Error: " & ex.Message)
        Finally
            connection.Close()
        End Try
    End Sub
End Module