BroadSQL Download
On this page
Documentation / Commands / SET PASSWORD

SET PASSWORD

Core command SE PA

Changes the password of the current connection's account, in the database (H2, Derby, HSQLDB) and in the CDF.

Syntax

SET PASSWORD

Examples

SET PASSWORD;

Details

Changes the password of the account you are connected as, in the database itself, then saves it in BroadSQL.

Supported databases

H2, Apache Derby (with NATIVE authentication) and HSQLDB. On any other database (Oracle, PostgreSQL, MySQL, MariaDB, SQL Server, Db2, SQLite and the others) the command refuses before anything is changed: change the password with the tools of that database or your identity provider, then update the password BroadSQL saved with EDIT CONNECTION <id> or in CONFIG.

Steps

The command takes no argument. It checks the connection first (database type, Derby authentication, the account the session is logged in as, no uncommitted changes), shows what it will change, then asks in turn:

  • Do you want to continue [y/n]?: only y or yes continues. On a connection of a Production Environment this question is the Production confirmation;
  • the master password, to authenticate;
  • the new password of the account, twice.

The database password is changed first. BroadSQL then opens a new connection with the new password to prove it, and only then saves the new password in the CDF. The current connection stays open.

Results

Each step is reported. When the database refuses the change, nothing is changed anywhere. When the database password changed but BroadSQL could not save it, the message says so: save it with EDIT CONNECTION <id>. When the outcome cannot be established, BroadSQL keeps the previous password and tells you how to recover. Other saved connections that use the same account are listed: they keep the previous password until you update them.

Refusals

In CDF maintenance mode (use SET MASTER PASSWORD), with uncommitted changes (commit or roll back first), or when the master password is wrong, the new password is blank, holds a control character or is too long to be saved, or the two entries differ.

Last modified in release 5.5.0.

← All commands

Found something wrong or unclear on this page? , with the page address.