Generate Passwords with MyQL

Many applications store MD5-crypted passwords in the database. If you want to quickly create a new MD5-ed password, or you have forgotten your password, use the following query to get a new one:

SELECT MD5(”m0ntypy7hon”);

This query will return “4f249cbc2c10d41f866b64decd365e39″ which is the encrypted version of the string “ m0ntypy7hon”.

There are other function that crypt stings in MySQL using different algorithms, most notably PASSWORD() which is using MySQL”s own crypting algorithm.

SELECT PASSWORD( “m0ntypy7hon” ) ;

returns: “5216be9f6ead4434”