$ mysql -u craftuser -p

mysql> USE craftdatabasename;

mysql> SHOW TABLES;

mysql> SELECT username,password FROM craft_users;

mysql> UPDATE craft_users SET password='passwordhash' WHERE username='admin';