B4J Question Is it possible to create mysql database with b4j?

[Addo]

Good morning, currently i use b4j to connect to mysql database and do queries.
But can i create an mysql database within b4j using jSql or something?

 

[DonManfred]

I guess it depends on the Rights you gave to the Database for the User you are using.
If the user has the right it should work.

 

[Addo]

@DonManfred i am talking about creating database, not connecting to an existing database and doing queries . As example execution of this query

CREATE DATABASE db_name;

Is it possible to connect to mysql server using Jsql and create a database with it?

 

[Erel]

Yes, it should work. Run it with ExecNonQuery.

 

[Addo]

what i am confusing in is the right parameter that i should use in Sql Initialize. in order to create a database

'is this a correct Parameter ?
sql.Initialize("com.mysql.jdbc.Driver", "jdbc:mysql://localhost:"&dpPort&"/?characterEncoding=utf8")

i am not adding database in the parameter since i am not trying to connect to a Database instead iam trying to create one

 

[Erel]

Try it. It will take you exactly two minutes to test.

 

[Addo]

i confirm it is working as expected

i was confused here is the working example

Sub createdatabase
    
Dim sql As SQL


Try
    
sql.Initialize2("com.mysql.jdbc.Driver","jdbc:mysql://localhost:"&dpPort&"/?characterEncoding=utf8","root", "123")

Dim SQLQuery As String = "CREATE DATABASE anyname;"

sql.ExecNonQuery(SQLQuery)

sql.Close


Catch
Log(LastException)
End Try
    
    
End Sub

Thank you Guys .