MySQL Forums
Forum List  »  MySQL for Visual Studio

VB.Net & MySQL connection problem
Posted by: Pyay Phyo Kyaw
Date: October 18, 2016 10:09PM

Hello guys,

I am trying to develop VB.Net application with online MySQL database. MySQL Connector version is 6.9.5

I can able to connect VB.Net with Local Host database. But I can't connect with Online MySQL database. The error code is
----------------------------------------------
"Authentication with old password no longer supported, use 4.1 style passwords."
----------------------------------------------

My VB code is
----------------------------------------------
Dim DatabaseName As String = "aaa"
Dim server As String = "1.1.1.1"
Dim userName As String = "bbb"
Dim password As String = "123"

If Not conn Is Nothing Then conn.Close()

conn.ConnectionString = String.Format("server={0}; user id={1}; password={2}; database={3}; pooling=false", server, userName, password, DatabaseName)

Try
conn.Open()

MsgBox("Connected")
Catch ex As Exception
'txtID.Text = ex.ToString
MsgBox(ex.Message)
End Try
conn.Close()
----------------------------------------------


help me guys

Options: ReplyQuote


Subject
Views
Written By
Posted
VB.Net & MySQL connection problem
602
October 18, 2016 10:09PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.