Generate random password in MySQL

It’s very simple to generate random password in MySQL.

Here is sample MySQL query to generate random password.

SELECT substring(MD5(RAND()) from 1 for 10) AS password

To generate random password I’m going use three MySQL functions

1. RAND()

2. MD5()

3. SUBSTRING()

where RAND() function generates random numbers between 0 to 1.

SELECT RAND() AS num

Result :  0.20635062754745653

then MD5() function encrypts generated random number (0.20635062754745653) into encrypted formatted data. like below

SELECT MD5(RAND()) AS num

(ex. SELECT MD5(0.20635062754745653) AS num )

Result : 1e24663af0a4102936cec71d99219a4f

Finally SUBSTRING() function extracts specified length of characters from MD5() function generated string (1e24663af0a4102936cec71d99219a4f)

SELECT substring( MD5(RAND()) from 1 for 10 ) AS num

(ex SELECT substring(’1e24663af0a4102936cec71d99219a4f’ from 1 for 10 ) AS num )

Result : 1e24663af0

 .