Open Source RDBMS - Seamless, Scalable, Stable and Free

English | Login |Register


1
(click on this box to dismiss)

I forgot my DB password. How can I reset it?

The previoud employee used auto-saveed DB's password in the client tool. Unfortunately he didn't tell me what it is.

I cannot access a DB. On the console, is it possible to reset DB password? I know DBA is a username.

 

링크 댓글 쓰기 (0)
질문시간 작년
cottonspan
61
84 답변들
1

It happened all the time. :D

Unfortunately there is no way to reset DBA's password. Instead, you need to re-build another DB by using the current DB. It is quite nasty so I encourage you not to forget DBA's password never again.


1. If you don't know the current password,

1) Log in to the host that CUBRID is running.

2) Run a command cubrid unloaddb current_database_name to unload schema, data and indexes from the current DB. You will have 4 types of files in schema, objects, indexes, triggers.

3) Create a new DB with cubrid createdb new_database_name . You will import unloaded data and schema into a new DB.

4) open a file named "current_database_name.schema" and delete a following line.

call [find_user]('DBA') on class [db_user] to [auser];
call [set_password_encoded_sha1]('C53255317BB11707D0F614696B3CE6F221D0E2F2') on [auser]; -> DELETE!!
...

5) Now import schema, data, index, and triggers which were unloaded in 2) into a new DB by followin commands:
cubrid loaddb -s currnet_database_name_schema new_database_name

cubrid loaddb -d currnet_database_name_objects new_database_name

cubrid loaddb -i currnet_database_name_indexes new_database_name

cubrid loaddb -s currnet_database_name_trigger new_database_name

6) You can rename a new database name by cubrid renamedb from_db_name to_db_name if you want.

 

2. If you forgot CUBRID Manager admin password to log-in CM server, please refer to

http://www.cubrid.org/wiki_tools/entry/how-to-reset-admin-password-for-cubrid-manager


3. If you want to change DB user password with ALTER USER, please refer to

http://www.cubrid.org/wiki_tutorials/entry/change-database-user-password

 

 

링크 댓글 쓰기 (0)
답변시간 작년
cottonspan
61
tagged




You are either using a very old browser or a browser that is not supported.
In order to browse cubrid.org you need to have one of the following browsers:



Internet Explorer: Mozilla Firefox: Google Chrome: