pavan_kumar_ds
Level 5

Create database

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!
Labels (1)
0 Kudos
2 Replies
UtsabKarmakar
Flexera
Flexera

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
0 Kudos
pavan_kumar_ds
Level 5

Thanks a lot for your reply 🙂
0 Kudos