Hello. Thank you for your answer, but I don’t have the old password.
On Jun 29, 2016, at 3:22 PM, Lynn Carol Johnson lcj34@cornell.edu wrote:
I successfully changed my monetdb admin password by logging in as admin, then running this command:
sql>alter user set unencrypted password ’new password' using old password 'monetdb'; operation successful (50.027ms) sql>
Instructions here: https://www.monetdb.org/Documentation/SQLreference/Users https://www.monetdb.org/Documentation/SQLreference/Users
Note this only changes the password for the db into which you are logged.
From: users-list <users-list-bounces+lcj34=cornell.edu@monetdb.org mailto:users-list-bounces+lcj34=cornell.edu@monetdb.org> on behalf of Roman S <rashkur@gmail.com mailto:rashkur@gmail.com> Reply-To: Communication channel for MonetDB users <users-list@monetdb.org mailto:users-list@monetdb.org> Date: Tuesday, June 28, 2016 at 11:04 AM To: "users-list@monetdb.org mailto:users-list@monetdb.org" <users-list@monetdb.org mailto:users-list@monetdb.org> Subject: Resetting monetdb administrative password
Hello,
Can somebody tell me how to reset monetdb administrative password?
I’ve tried to stop mserver5, start it manually, oldp:=clients.getPasswordHash(“monetdb"); newp:=clients.backendsum("newpassword"); clients.changePassword(oldp, newp); Stoping it again and start in normal mode
But it didn’t help:
mclient --database=mydb --user=monetdb password:<usingnewpass> InvalidCredentialsException:checkCredentials:invalid credentials for user 'monetdb' _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list