I am looking to generate a cryptographically secure string for password reset in MySQL. I know I could do this at the application level in PHP; but that requires the OpenSSL extension which many of my customers might not have.
If I can do it in MySQL 5 in a secure way that is widely available that would be ideal. Is this possible?
Note: This is for generating a secure token for password reset. It doesn't have anything to do with a secure connection, so using https is not a solution.