Reset NextCloud user password from command line
You can use lost password link in login page to reset password. If you don’t have a valid email set or mail server not working, you can reset the password using SSH.
NextCloud users are stored in table oc_users. If you don’t know the user name, you can use following SQL command to see all available users.
select * from oc_users;
To reset password for a user, login to SSH, go to DocumentRoot for the web site. This is the folder where you uploaded NextCloud files. Then run
php occ user:resetpassword USERNAME_HERE
On following screenshot, i reset password for user “admin”.
It will ask you to enter password 2 times.
See NextCloud