See example on https://www.monetdb.org/Documentation/Manuals/SQLreference/SQLSyntaxOverview... for changing the default password of the monetdb system user.
If you can no longer connect to mserver5 via mclient program after having changed the password for the monetdb user, you may want to inspect if there is a .monetdb file and if it still contains the old password for the user=monetdb. If so, mclient will use it to connect to mserver5, but will fail with: InvalidCredentialsException:checkCredentials:invalid credentials for user 'monetdb'
To resolve it, edit the .monetdb file and change the line containing: password=monetdb
See https://www.monetdb.org/Documentation/mclient-man-page Description section, for more information on the .monetdb file
On 19-12-2019 22:53, Jonathan Speiser wrote:
Hello,
I had tried changing the password on my monetdb server (MonetDB 5 server v11.29.3 "Mar2018") but after rebooting it seems I am locked out from mclient. Is there any way I can change the monetdb user password from mserver5?
Thank you for your help Jon
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list