CUBRID createdb database password
Hello,
I tried using the:
"cubrid createdb XE"
command to create a database and I looked through the options that cubrid command offers and found no way to set the database password. In cubrid manager it works, but I want to create it using an automated script, so I need to somehow set the password during or after the "cubrid createdb" command. Is it possible in any way ?
Best regards,
Catalin
I couldn't find any options in command line, I think you need to connect to the database and call some methods from within SQL, like here http://www.cubrid.org/manual/821/en/User%20Authorization%20Management%20Method
I found one solution to this. I used a initialization script and ran the command:
cubrid createdb --csql-initialization-file=change_password.sql XE
Where change_password.sql is a file that contains the following line:
ALTER USER dba PASSWORD 'any_password_here';
The name of the file can be any name you want.