Tool to match mysql password encryption

Question

I've created a user ... but forgotten the password

mysql> create user 'blayo'@'%' identified by 'right';

Which Linux command line tool can encrypt the password the same way mysql does ?

mysql> select Password,User from mysql.user
------------------------------------------+-------+
*920018161824B14A1067A69626595E68CB8284CB | blayo |

...to be sure I use the right one

$ tool right
*920018161824B14A1067A69626595E68CB8284CB

Answer 1

Just use MySQL:

select password('foo');

PASSWORD('FOO')

*F3A2A51A9B0F2BE2468926B4132313728C250DBF

Answer 2

MySql uses SHA1 to hash the password in the following way and then prefix's it with a star:

SHA1(SHA1(password));

The argument to the outer SHA1 must be the binary result of the inner hash for it to work properly.

source: MySQL source code and the following link:

http://palominodb.com/blog/2011/12/04/hashing-algorithm-mysql-password