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
浙公网安备 33010602011771号