Skip to content

Instantly share code, notes, and snippets.

@erochest

erochest/insert_user.sql

Created August 6, 2014 13:51
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save erochest/a9dbf00baa3a7b32a869 to your computer and use it in GitHub Desktop.
Save erochest/a9dbf00baa3a7b32a869 to your computer and use it in GitHub Desktop.
Download ZIP
Insert an Omeka user into the database from the mysql console.
Raw
insert_user.sql
SET @salt := SUBSTR(SHA1('salt'), 1, 16);
INSERT INTO omeka_users (username, name, email, password, salt, active, role)
VALUES ('err8n', 'Eric', 'err8n@virginia.edu', SHA1(CONCAT(@salt, 'err8n')), @salt, 1, 'super');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment