Skip to content

Instantly share code, notes, and snippets.

@andriyun

andriyun/create-remove_database-user.sql

Created January 3, 2019 12:01
Show Gist options
  • Save andriyun/8099f083af910c45924e440200cfca89 to your computer and use it in GitHub Desktop.
Save andriyun/8099f083af910c45924e440200cfca89 to your computer and use it in GitHub Desktop.
Download ZIP
SQL sources management (create/remove database/user)
Raw
create-remove_database-user.sql
CREATE DATABASE db_name;
GRANT ALL PRIVILEGES ON db_name.* TO 'db_user'@'localhost' IDENTIFIED BY '[pass]';
DROP DATABASE db_name;
DROP user db_user@localhost;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment