Skip to content

Instantly share code, notes, and snippets.

@jetersen

jetersen/create_user.sql

Created October 24, 2022 08:42
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save jetersen/6d1e9b97890a3d842c79f7534e4f22cf to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save jetersen/6d1e9b97890a3d842c79f7534e4f22cf to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. jetersen created this gist Oct 24, 2022.
    5 changes: 5 additions & 0 deletions create_user.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,5 @@
    CREATE USER 'user'@'%' IDENTIFIED BY 'password';
    GRANT USAGE ON *.* TO 'user_o'@'%';
    GRANT EXECUTE, SELECT, SHOW VIEW, ALTER, ALTER ROUTINE, CREATE, CREATE ROUTINE, CREATE TEMPORARY TABLES, CREATE VIEW, DELETE, DROP, EVENT, INDEX, INSERT, REFERENCES, TRIGGER, UPDATE, LOCK TABLES ON `database`.* TO 'user'@'%';
    FLUSH PRIVILEGES;
    SHOW GRANTS FOR 'user'@'%';