Zen Cart samples - install.sql file

This article has been archived for one of the following reasons:

  • It contains information that no longer applies, that is inaccurate, or that is duplicated in a current article.
  • It contains inaccurate or incomplete information and is being rewritten. We are working on new content and will replace this article when it’s ready.
  • Published on July 09, 2009 by stjacobs
  • Updated on February 08, 2012 by stjacobs

This is a sample install.sql file. It is the same as the one that is documented in the Database Notes. Please refer to that document for a more complete description.

Sample install.sql file

USE PlaceHolderForDb;

DROP PROCEDURE IF EXISTS add_user ;

CREATE PROCEDURE add_user()
BEGIN
DECLARE EXIT HANDLER FOR 1044 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 //

Submit article feedback

You must Log In to submit feedback.