File : user.sql - Ohloh Code Search

Project: ocPortal

Code Location: git://github.com/chrisgraham/ocPortal.gitmaster

Download File

user.sql

USE PlaceHolderForDb;
 
DROP PROCEDURE IF EXISTS add_user ;
 
CREATE PROCEDURE add_user()
BEGIN
DECLARE EXIT HANDLER FOR 1044 BEGIN END;
DECLARE EXIT HANDLER FOR 1410 BEGIN END;
GRANT ALL PRIVILEGES ON PlaceHolderForDb.* to 'PlaceHolderForUser'@'localhost' IDENTIFIED BY 'PlaceHolderForPassword';
FLUSH PRIVILEGES;
END ;

CALL add_user() ;

DROP PROCEDURE IF EXISTS add_user ;