金仓数据库(kingbase)的system用户被锁的解锁步骤
今天发现我安装的金仓数据库(kingbase)的system用户被锁了,无法登陆。百度搜了下,使用SUPERMANAGER_V8ADMIN可以解锁,试了下果然如此。解锁步骤如下:
用户:SUPERMANAGER_V8ADMIN
密码:KINGBASEADMIN
端口:54321
数据库:TEST
[kingbase@database ~]$ ksql -USUPERMANAGER_V8ADMIN -WKINGBASEADMIN -p54321 TEST
ksql (V008R003M002B0010)
Type "help" for help.
TEST=#
TEST=# enable user SYSTEM; # 结果提示:SYSTEM密码已经过期,必须先修改它
ERROR: The password has expired, you must change it.
TEST=#
TEST=# alter user system with password 'system@123' ; # 修改SYSTEM用户的密码
ALTER ROLE
TEST=#
TEST=# enable user SYSTEM ; # 解锁SYSTEM用户
ENABLE USER
TEST=#
TEST=# enable user system ; # 再次执行,提醒SYSTEM用户没有被锁。
WARNING: user "SYSTEM" does not be locked
ENABLE USER
TEST=#
TEST-# \q # 退出
[kingbase@database ~]$