Skip to content

Instantly share code, notes, and snippets.

@thecodeholic

thecodeholic/create-db-and-user-in-mysql.sql

Last active August 20, 2019 08:47
Show Gist options
  • Save thecodeholic/827e55a3fcf548639c0eb23b62393979 to your computer and use it in GitHub Desktop.
Save thecodeholic/827e55a3fcf548639c0eb23b62393979 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
create-db-and-user-in-mysql.sql
CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';
CREATE DATABASE database_name DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
GRANT ALL PRIVILEGES on database_name.* TO 'user'@'localhost';
FLUSH PRIVILEGES;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment