Skip to content

Instantly share code, notes, and snippets.

@hectorperez
Last active August 29, 2015 14:00
Show Gist options
  • Save hectorperez/11222278 to your computer and use it in GitHub Desktop.
Save hectorperez/11222278 to your computer and use it in GitHub Desktop.
MySQL: Create database, user & give privileges
CREATE DATABASE new_database;
CREATE USER 'new_user'@'localhost' IDENTIFIED BY 'new_password';
GRANT ALL PRIVILEGES ON your_database_name.* TO 'your_user'@'localhost';
FLUSH PRIVILEGES;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment