Dim conn As New MySql.Data.MySqlClient.MySqlConnection
Dim myConnectionString As String
myConnectionString = "server=xxx.yyy.zzz.aaaa:3306;" _
& "uid=aaa;" _
& "pwd=bbb;" _
& "database=ccc"
Try
conn.ConnectionString = myConnectionString
conn.Open()
Catch ex As MySql.Data.MySqlClient.MySqlException
MessageBox.Show(ex.Message)
End Try
conn.Close()
服务器是 Ubuntu 18.04
这是错误截图。错误截图
以前有人解决过这个问题吗?谢谢您的支持。
我喜欢从定义的连接参数构建连接字符串 - 无论是否使用专用构建器:
Dim (or Const) Server As String = "MyServer"
Dim (or Const) Port As UInteger= 3456
Dim (or Const) Database As String = "MyDatabase"
Dim (or Const) UserId As String = "MyUser"
Dim (or Const) Password As String = "MyPassword"
Dim mySql As New MySql.Data.MySqlClient.MySqlConnectionStringBuilder() With {
.Server = Server,
.Port = Port,
.Database = Database,
.UserId = UserId,
.Password = Password
}
MySQL String Builder ( mySql.ConnectionString
) 的结果:
server=MyServer;port=3456;database=MyDatabase;user id=MyUser;password=MyPassword
或者自己动手:
Dim myConn As String = $"Server={Server};Port={Port};Database={Database};Uid={UserId};Pwd={Password}"
(注意UserId和Password 的备用参数命名。)
一个有用的资源是连接字符串网站:https : //connectionstrings.com。
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句