Android Question How to change port number in jdbcSQL

4rdn1_s

Member
Hello Friends,

I wanna ask, is there any way to change the port on jdbcSQL, because i'm using jdbcSQl for my remote database connection and the server is using port other than 3306 for mysql database
 

DonManfred

Expert
Licensed User
Longtime User
B4X:
    Dim db As SQL
    db.InitializeAsync("DB","com.mysql.jdbc.Driver", "jdbc:mysql://domainorip:YOURPORT/databasename?characterEncoding=utf8","username","password")
    Wait For DB_Ready(Success As Boolean)
    Log(Success)
    If Success = False Then
        Log(LastException)
        Return
    End If
 
Upvote 1

4rdn1_s

Member
B4X:
    Dim db As SQL
    db.InitializeAsync("DB","com.mysql.jdbc.Driver", "jdbc:mysql://domainorip:YOURPORT/databasename?characterEncoding=utf8","username","password")
    Wait For DB_Ready(Success As Boolean)
    Log(Success)
    If Success = False Then
        Log(LastException)
        Return
    End If
Thank DonManFred. It work
 
Upvote 0
Top