Skip to content

Instantly share code, notes, and snippets.

@scottoffen

scottoffen/create-mysql-db.sql

Last active February 1, 2016 20:35
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save scottoffen/10560794 to your computer and use it in GitHub Desktop.
Save scottoffen/10560794 to your computer and use it in GitHub Desktop.
Download ZIP
Create New MySQL Database (with user)
Raw
create-mysql-db.sql
-- Using GRANT for creating new users has been deprecated and will be removed in the future
-- as of 5.7.1
-- Create a new user
create user '[username]'@'[host]' identified by '[password]';
-- Create a new database/user
create database [schema];
-- Grant user access to database
grant all on [schema].* to '[username]'@'[host]' identified by '[password]';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment