MYSQL DB create dataBase

[darzanmihai]

I have found this topic about handling a MySQL DB: http://www.autoitscript.com/forum/index.ph...showtopic=20814

, but i couldn't find how to create a MySql DB... I have searched Google and found some topics, but I am still couldn't understand.

Could someone give me an example of creating a DB with username and password.

Thank you!

[Jos]

Have you looked at the available set of UDF's in the standard installers Helpfile?

"SQLite Management"

Jos

[darzanmihai]

Have you looked at the available set of UDF's in the standard installers Helpfile?

"SQLite Management"

Jos

Yes, I have worked with those SQLITE functions, but I am talking about MySQL...

Thx for reply anyway.

Mihai

[darzanmihai]

someone?

[darzanmihai]

nobody?

[ProgAndy]

Try these UDFs: http://www.autoitscript.com/forum/index.php?showtopic=85617

Then use something like this:

_MySQL_InitLibrary()
$MysqlConn = _MySQL_Init()

$connected = _MySQL_Real_Connect($MysqlConn,"HOST","USER","PASS")

_MySQL_Real_Query($MysqlConn, "CREATE DATABASE *********")

; Close connection
_MySQL_Close($MysqlConn)
; exit MYSQL
_MySQL_EndLibrary()

For more information about CREATE DATABASE look here: http://dev.mysql.com/doc/refman/5.1/en/create-database.html

Edited May 3, 2009 by ProgAndy

[darzanmihai]

Try these UDFs: http://www.autoitscript.com/forum/index.php?showtopic=85617

Then use something like this:

_MySQL_InitLibrary()
$MysqlConn = _MySQL_Init()

$connected = _MySQL_Real_Connect($MysqlConn,"HOST","USER","PASS")

_MySQL_Real_Query($MysqlConn, "CREATE DATABASE *********")

; Close connection
_MySQL_Close($MysqlConn)
; exit MYSQL
_MySQL_EndLibrary()

For more information about CREATE DATABASE look here: http://dev.mysql.com/doc/refman/5.1/en/create-database.html

Thx for reply!

I have one question thought...I whant to create a database on my site, but I have truble conecting to it. I have tryed the host,user and pass from the ftp and from the administration pannel but doesn't conect. What settings should I use?

[Hest]

Thx for reply!

I have one question thought...I whant to create a database on my site, but I have truble conecting to it. I have tryed the host,user and pass from the ftp and from the administration pannel but doesn't conect. What settings should I use?

Some sites will only allow connection from localhost to prevent connections from outside, so first check if they allow you to connect.

[darzanmihai]

Some sites will only allow connection from localhost to prevent connections from outside, so first check if they allow you to connect.

how could I verify if connecting from outside is allowed?