暂无图片
分享
肖杰
2021-08-24
Gaussdb密码疑问

gaussdb 100默认密码修改后在nomount,mount状态下无法用新密码登录,只能用默认密码登录,反复测试也是如此,测试结果如下:

默认密码:Changeme_123
修改后的新密码:Gaussdb_123

1,open状态下新密码正常登录

SQL> select status from dv_database;

STATUS              
--------------------
OPEN                

1 rows fetched.

SQL> quit

[omm@dm bin]$ zsql sys/Gaussdb_123@127.0.0.1:1888

Warning: SSL connection to server without CA certificate is insecure. Continue anyway? (y/n):y
connected.


SQL> quit

2,nomount,mount状态下只能用默认密码登录,新密码无法登录

[omm@dm bin]$ python zctl.py -t stop 
Successfully stopped instance.
[omm@dm bin]$ python zctl.py -t start -m nomount  
Successfully started instance.
[omm@dm bin]$ zsql sys/Gaussdb_123@127.0.0.1:1888

Warning: SSL connection to server without CA certificate is insecure. Continue anyway? (y/n):y
GS-00329, Incorrect user or password

[omm@dm bin]$ zsql sys/Changeme_123@127.0.0.1:1888

Warning: SSL connection to server without CA certificate is insecure. Continue anyway? (y/n):y
connected.


SQL> alter database mount;

Succeed.

SQL> quit

[omm@dm bin]$ zsql sys/Gaussdb_123@127.0.0.1:1888

Warning: SSL connection to server without CA certificate is insecure. Continue anyway? (y/n):y
GS-00329, Incorrect user or password

[omm@dm bin]$ zsql sys/Changeme_123@127.0.0.1:1888

Warning: SSL connection to server without CA certificate is insecure. Continue anyway? (y/n):y
connected.

SQL>

查了官方文档,也没有这方面的解释,有木有大佬出来解释一下

收藏
分享
1条回答
默认
最新
肖杰
问题已关闭: 问题已经得到解决
暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏