1mysql> SELECT Host, User, authentication_string, PASSWORD('forgotten') FROM mysql.user WHERE User='nonexistant';
2+-------------+-------------+-------------------------------------------+-------------------------------------------+
3| Host | User | authentication_string | PASSWORD('forgotten') |
4+-------------+-------------+-------------------------------------------+-------------------------------------------+
5| 192.168.0.1 | nonexistant | *AF9E01EA8519CE58E3739F4034EFD3D6B4CA6324 | *70F9DD10B4688C7F12E8ED6C26C6ABBD9D9C7A41 |
6| % | nonexistant | *AF9E01EA8519CE58E3739F4034EFD3D6B4CA6324 | *70F9DD10B4688C7F12E8ED6C26C6ABBD9D9C7A41 |
7+-------------+-------------+-------------------------------------------+-------------------------------------------+
82 rows in set, 1 warning (0.00 sec)
9