Here is a quick and simple way to generate a password your
application using MySQL.
This query will create a upper and lower case randomly generated
password in length and values.
SELECT CONCAT(UCASE(SUBSTRING( SUBSTRING(MD5(RAND()),
FLOOR( 1 + (RAND() * 5)) , FLOOR( 8 + (RAND() * 15 ))
) , FLOOR( 1 + (RAND() * 4 )) , FLOOR( 4 + (RAND() *
12 )) )),
SUBSTRING('!@#$%^&*', FLOOR( 1 + (RAND() * 4)) , FLOOR(
1 + (RAND() * 8)) ),
SUBSTRING( SUBSTRING(MD5(RAND()), FLOOR( 1 + (RAND() * 5))
, FLOOR( 8 + (RAND() * 15 )) ) , 5)) as password
\G
This query will take a random value for the 1st part of the
dynamic password and upper case it when applicable then the
second half it adds some symbols then the remaining is in lower
case because MD5 does that automatically. You of course can
adjust whatever symbols you would prefer.
…
Showing entries 1 to 1
Jul
25
2015
Showing entries 1 to 1