How to change the solidDB root password in the Connect Direct DBASE?

Body

Run solsql.exe from a Command Prompt and connect to your database using root and its the password:

> "[install_dir]\solidDB6.5\bin\solsql.exe" "tcp 23460" root oldpwd
IBM solidDB SQL Editor (teletype) - Version: 6.5.0.6 Build 2011-05-30
Copyright Oy International Business Machines Ab 1993, 2011.
Connected to 'tcp 23460'.
Execute SQL statements terminated by a semicolon.
Exit by giving command: exit
 

Issue the following commands to set the new password and save it:

solsql> ALTER USER root IDENTIFIED BY newpwd;
Command completed successfully, 0 rows affected.

solsql> COMMIT WORK;
Command completed successfully, 0 rows affected.

solsql> exit;
IBM solidDB SQL Editor exiting.
 

Afterwards run CD Database Wizard again to configure the new solidDB password in Connect:Direct.

For more details, see Changing administrator's username and password in the IBM solidDB 6.5 Administrator Guide.