bsduser1# echo -n "newpassword" | md5
5e9d11a14ad1c8dd77e98ef9b53fd1ba
bsduser1# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.67-log OpenBSD port: mysql-server-5.0.67

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use familyblogDB;
Database changed
mysql> show tables;
+------------------------+
| Tables_in_familyblogDB |
+------------------------+
| comments               |
| links                  |
| options                |
| postmeta               |
| posts                  |
| term_relationships     |
| term_taxonomy          |
| terms                  |
| usermeta               |
| users                  |
+------------------------+
10 rows in set (0.02 sec)

mysql> SELECT ID, user_login, user_pass FROM users;
+----+------------+------------------------------------+
| ID | user_login | user_pass                          |
+----+------------+------------------------------------+
|  1 | admin      | $P$BHy.ZzehYpByn8FESaVDsjxUCWjoqe1 |
+----+------------+------------------------------------+
1 row in set (0.12 sec)

mysql> UPDATE users SET user_pass="86f8212c7c8380d55613bf5ead17822c" WHERE ID = 1;
Query OK, 1 row affected (0.05 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> SELECT ID, user_login, user_pass FROM users;
+----+------------+----------------------------------+
| ID | user_login | user_pass                        |
+----+------------+----------------------------------+
|  1 | admin      | 5e9d11a14ad1c8dd77e98ef9b53fd1ba | 
+----+------------+----------------------------------+
1 row in set (0.00 sec)

mysql> \q
Bye