Thanks. I have been looking into mysql's security functions. It is safer to use SHA2.
PHP Code:
DELIMITER $$
DROP FUNCTION IF EXISTS generateSalt$$
CREATE FUNCTION generateSalt()
RETURNS VARCHAR(255)
DETERMINISTIC
BEGIN
DECLARE x INT;
DECLARE s VARCHAR(255);
SET s = '';
SET x = 0;
WHILE x < 10 DO
SET s = CONCAT(s,CHAR(FLOOR(34+(RAND()*93))));
SET x = x + 1;
END WHILE;
RETURN s;
END$$
DELIMITER ;
PHP Code:
SET s = generateSalt();
SET pass = SHA2(CONCAT(s, pass), 256);