sybase sa密碼重置

sa 密碼忘記解決之道

1、編輯/opt/sybase/ASE-*/install下的RUN_servernamee在最后加上-psa

2、然后重啟sybase<記得先kil lsybase進程>：

# cd /opt/sybase/ASE-*/install/

#. /opt/sybase/SYBASE.sh

# ./startserver -f ./RUN_DBSVR

在輸出控制臺搜索password 關鍵字即可找到新密碼。

===========================================================================

00:00000:00001:2006/10/31 08:04:02.52 server  Completed cleaning up the default data cache for database 'sybsystemprocs'.

00:00000:00001:2006/10/31 08:04:02.52 server  Checking external objects.

00:00000:00001:2006/10/31 08:04:02.53 server  The transaction log in the database 'sybsystemprocs' will use I/O size of 16 Kb.

00:00000:00001:2006/10/31 08:04:02.60 server  Database 'sybsystemprocs' is now online.

New SSO password for sa:hactgvzwzgfbv3

00:00000:00011:2006/10/31 08:04:02.62 kernel  network name 10.71.214.209, interface IPv4, address 10.71.214.209, type tcp, port 4100, filter NONE

00:00000:00011:2006/10/31 08:04:02.62 kernel  A listener with protocol tcp, host 10.71.214.209, port 4100, engine 0 already exists.

00:00000:00011:2006/10/31 08:04:02.62 kernel  network name 127.0.0.1, interface IPv4, address 127.0.0.1, type tcp, port 4100, filter NONE

01:00000:00000:2006/10/31 08:04:02.91 kernel  Network and device connection limit is 19970.

01:00000:00000:2006/10/31 08:04:02.91 kernel  ASE - Dynamic Pluggable Component Interface is disabled

....................................

===============================================================================

3、然后使用如下命令改回來你需要的密碼即可：

exec   sp_password   'hactgvzwzgfbv3', '111111', 'sa'

go

4、最后

編輯/opt/sybase/ASE-*/install下的RUN_servername 刪除-psa 行

摘自 velex的專欄

生活不易，碼農辛苦
如果您覺得本網站對您的學習有所幫助,可以手機掃描二維碼進行捐贈