Generate random password in MySQL

Posted 4:35 pm by muni & filed under MYSQL, PHP.

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

How to generate new 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

 .