Welcome to my blog!

Here I try to keep useful information about IT, mostly related to Web development and Linux stuff. Any comments or feedback that you might have will be much appreciated!

Thanks,
Tomi

Quick MySQL random passwords

Filed Under (Databases) by admin on 02-09-2009

If you need to quickly generate passwords within MySQL, you could try one of the following methods:

  1. SELECT CONV(FLOOR(RAND() * 99999999999999), 10, 3);
  2. SELECT SUBSTR(MD5(RAND() * 99999999999999), 1, 10);

No Comments
Read More
Subscribe to Rss Feed : Rss