Create database

[pavan_kumar_ds]

Hello friends,

I have a question,how can we create database using the script?? i tried using "mysql -uroot -proot CREATE DATABASE %abc%" using execute script action,but it fails.Can you please suggest how can i do this??I have mysql installed in my system!

[UtsabKarmakar]

Hi Pavan,

Try giving the full path to the 'mysql'.
In Windows eg: C:\\bin\mysql.exe
In Linux eg: /usr/local/mysql/bin/mysql

Or
You can 'cd' to and then run your sql_cmd.

Or
Append the full path of mysql till bin folder in environment variable 'PATH'.


Regards
Utsab Karmakar

[pavan_kumar_ds]

Thanks a lot for your reply 🙂