Nov 122022
 

One of my owncloud instances is unable to change a new users password from the web UI. This seems to happen often and I couldnt figure out how. But you can change it directly in the SQL database:

– Create the hash e.g. on Cyberchef. Select bcrypt 10 rounds and prepend “1|” to the resulting hash:

– Login to SQL database, e.g.
mysql -h mysql.owncloud.de -u myuser -p mydatabase

– Update new PW, dont forget the 1| in front of the hash
update users set password='1|$2a$10$xxxxxxxxxxxxxxxxxxxxxxxxxxxxx' where uid="yyyyyyy";

Done.

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

(required)

(required)