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条回答
默认
最新
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
墨值悬赏

评论
