Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Change database user password


To change your database user password, execute the following SQL.

ALTER USER user_name PASSWORD 'any_password_here_in_single_quotes';

You may execute it using CSQL command line SQL Interpreter or CUBRID Manager.

CSQL Example

Before changing the password, make sure your database has been started.

~$ csql -u dba demodb
csql> ALTER USER dba PASSWORD 'my_new_pass';
Current transaction has been committed.
1 command(s) successfully processed.
csql>

Remember that in order to change a user password you need to be logged in as an admin user (or a user who has a permission to change a user password). In our case, dba is an admin user. Otherwise, you will get an error saying "UDPATE authorization failure".

Alternatively, you can set the database user password at the database creation time.

comments powered by Disqus
Page info
viewed 4506 times
translations en
Author
posted 2 years ago by
CUBRID
Contributors
updated last year by
View revisions
Share this article