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
Connect to MYSQL Server to "Create database"
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller
Connect to MYSQL Server to "Create database"
Founder & Developer @ MakeShyft R.D.A - https://www.makeshyft.com
Build Software with AppStarterStack for Livecode - https://www.AppStarterStack.com
Save Time with The Time Saver's Toolbox - https://www.TimeSaversToolbox.com
Build Software with AppStarterStack for Livecode - https://www.AppStarterStack.com
Save Time with The Time Saver's Toolbox - https://www.TimeSaversToolbox.com
(solved) Connect to MYSQL Server to "Create database"
local ComputerReturn,ResultVariable
put "mysql -u" & UserName & " -p" & Password & " -e " & "'" & "create database " & DatabaseName & "'" & ";" into ComputerReturn
set defaultfolder to PathOfMySQLBin
put shell (ComputerReturn) into ResultVariable
put "mysql -u" & UserName & " -p" & Password & " -e " & "'" & "create database " & DatabaseName & "'" & ";" into ComputerReturn
set defaultfolder to PathOfMySQLBin
put shell (ComputerReturn) into ResultVariable
Founder & Developer @ MakeShyft R.D.A - https://www.makeshyft.com
Build Software with AppStarterStack for Livecode - https://www.AppStarterStack.com
Save Time with The Time Saver's Toolbox - https://www.TimeSaversToolbox.com
Build Software with AppStarterStack for Livecode - https://www.AppStarterStack.com
Save Time with The Time Saver's Toolbox - https://www.TimeSaversToolbox.com