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的專欄
