Skip to content

Instantly share code, notes, and snippets.

@davidromani

davidromani/MySQL create user & database and grant privileges

Last active May 2, 2018 10:11
Show Gist options
  • Save davidromani/2849445 to your computer and use it in GitHub Desktop.
Save davidromani/2849445 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL create and grant
Raw
MySQL create user & database and grant privileges
CREATE DATABASE `<dbname>` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE USER <user> IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON <dbname>.* TO <user>@localhost;
FLUSH PRIVILEGES;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment