Page 1 of 1

Connect to MYSQL Server to "Create database"

Posted: Tue Jan 19, 2016 12:06 am
by makeshyft
Hi everyone,

Am I correct in thinking that there is no way to connect to a myseql server without specifying the database to which to connect to?

I want to connect to a server and create database via SQL command.

Am I looking at command line for each desktop platform?

Thanks

Tom

(solved) Connect to MYSQL Server to "Create database"

Posted: Tue Jan 19, 2016 7:40 am
by makeshyft
local ComputerReturn,ResultVariable

put "mysql -u" & UserName & " -p" & Password & " -e " & "'" & "create database " & DatabaseName & "'" & ";" into ComputerReturn

set defaultfolder to PathOfMySQLBin
put shell (ComputerReturn) into ResultVariable