GaussDB修改密码报错“The old password can not be NULL, please input your old password with 'replace' grammar.```”

gaussdb=> alter user root password 'root@1234';
ERROR:  The old password can not be NULL, please input your old password with 'replace' grammar.

提示需要输入replace语句

gaussdb=> alter user root password 'root@1234' replace 'SYQ@1999';
ERROR:  syntax error at or near "replace"

... 坑爹呢?一定要用identified by才可以

gaussdb=>  alter user root identified by 'root@1234' replace 'SYQ@1999';
ALTER ROLE

posted on 2025-01-19 22:36  yq1DB  阅读(208)  评论(0)    收藏  举报

导航