Skip to content

Instantly share code, notes, and snippets.

@dmishh

dmishh/create-user-and-db.sql

Created August 1, 2013 20:34
Show Gist options
  • Save dmishh/6135027 to your computer and use it in GitHub Desktop.
Save dmishh/6135027 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
create-user-and-db.sql
CREATE USER 'USER'@'localhost' IDENTIFIED BY 'PWD';
GRANT USAGE ON *.* TO 'USER'@'localhost' IDENTIFIED BY 'PWD' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;
CREATE DATABASE IF NOT EXISTS `DATABASE`;
GRANT ALL PRIVILEGES ON `DATABASE`.* TO 'USER'@'localhost';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment