Alex's Public Information Portal.
2 entries from DB2 tagged with 'Password'
这篇文章 描述了从DB 恢复MT 控制台密码的方法。
$ perl -e "print crypt('password', 'ac');"
mysql> update mt_author set author_password = '???' where author_name = 'XXX';
使用print 出来的字符串替换"???"，"XXX" 是登录用户名。然后使用"password" 作为密码即可登录。
"password" 与 "ac" 可随意更改。
DB2 depends on operation system level authorization to control DB2 system access.
In some case, our db2 account only allows to connect to instance or database, but not log on the system. In other words, we are not able to use the account to get a shell on unix or logon locally on windows.
As usual, when we need to change db2 password, we take action on the system level because it's more frank. But in the case above that we can't get logon, we have to do it on db2 level. There are 2 ways.
Right click on a database name, then choose "Change password".
Note: When more than one databases live in same system, we might share the same account in multi-database. Changing password for one of them will affect all databases in this system. In other words, we don't need to do the change on each database, we could choose any we have privileges on the system.
Limitation: We are not able to change our password in the case of that we are only allowed to attach to the node but not connect to any database, or we don't get the catalog information for any database in the node.
For this limitation, it works out with the 2nd way.
We could use CLP and CE to change password for databases and nodes that we connected or attached to.
C:\> db2 connect to SAMPLE user TEST using OLDPWD new NEWPWD confirm NEWPWD
C:\> db2 connect to SAMPLE user TEST using OLDPWD change password
C:\> db2 attach to NODE user TEST using OLDPWD new NEWPWD confirm NEWPWD
C:\> db2 attach to NODE user TEST using OLDPWD change password
If you use an RSS reader, you can subscribe to a feed of all future entries tagged 'Password'. [What is this?]
