Pronounceable Password Generator is written using a MySQL Stored Procedure. This is a very basic procedure to generate passwords for up to 8 characters randomly. The generated password is pronounceable and uses constants and vowels. The password created using this procedure is very weak and can be judged easily. You can add more characters to this constant and vowels and make customization. Code originally written in PHP by Max Dobbie-Holman. With this code a e.g. Trigger can generate a username and password without any external code. Generated tokens are like: tetrasun, goldulog, pudmumon, cemracet, rammedar, pollageb, nicgebom. This procedure can of course be modified to make stronger passwords.

DROP PROCEDURE makeToken;
 
DELIMITER //
 
CREATE PROCEDURE makeToken ()
BEGIN
DECLARE x INT DEFAULT 0;
DECLARE consts CHAR(12) DEFAULT 'bcdgklmnprst';
DECLARE vowels CHAR(5) DEFAULT 'aeiou';
DECLARE const CHAR(12) DEFAULT '';
DECLARE vow CHAR(12)  DEFAULT '';
 
WHILE x < 6 DO
SET const = CONCAT(const, SUBSTR(consts, FLOOR(1 + (RAND() * 12)),1));
SET vow = CONCAT(vow, SUBSTR(vowels, FLOOR(1 + (RAND() * 5)),1)); 
SET x = x + 1;
END WHILE;
 
INSERT INTO users SET password=CONCAT(SUBSTR(const, 1, 1), SUBSTR(vow, 1, 1), SUBSTR(const, 3, 1), SUBSTR(const, 2, 1), 
SUBSTR(vow, 2, 1), SUBSTR(const, 4, 1), SUBSTR(vow, 4, 1), SUBSTR(const, 5, 1));
 
END;
//
DELIMITER ;

Current Tags

You must be logged in to tag this tool

No Comments yet