UPDATE Statement

This example updates a users password in a redmine mysql database.

In this case, the username is "redmine".

mysql> UPDATE users SET hashed_password='353e8061f2befecb6818ba0c034c632fb0bcae1b' WHERE login='redmine';
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0
 
mysql> update users set salt='' where login='redmine';
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0
(Comments)

Comments