Generate MySQL PASSWORD using command line

$ echo -n foo | openssl sha1 -binary | openssl sha1 | tr 'a-z' 'A-Z' | sed 's/^/\*/'

Make sure old_passwords=0 in your /etc/my.cnf