Skip to content

Instantly share code, notes, and snippets.

@python-consulting
Last active August 29, 2015 13:56
Show Gist options
  • Save python-consulting/8861203 to your computer and use it in GitHub Desktop.
Save python-consulting/8861203 to your computer and use it in GitHub Desktop.
SQL Database + User creation
# Database name : db_name
# Password : db_pwd
CREATE DATABASE db_name;
ALTER DATABASE db_name CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
GRANT ALL ON db_name.* TO 'db_name_user'@'localhost' IDENTIFIED BY 'db_pwd';
FLUSH PRIVILEGES;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment