Reset Password for Movable Type User via MySQL

login to mysql

$ mysql -u USERNAME -p DATABASENAME

find id of user

> select author_name, author_id from mt_author;
+---------------+-----------+
| author_name   | author_id |
+---------------+-----------+
| beau          |         1 |
| quinn         |         2 |
| ryan          |         3 |
| jono          |         4 |
+---------------+-----------+

issue the command using the correct author id from the table

> update mt_author set author_password = encrypt('foobar') where author_id = 1;