Skip to content

Instantly share code, notes, and snippets.

@sigmike

sigmike/create user and database

Created July 9, 2010 20:28
Show Gist options
  • Save sigmike/470015 to your computer and use it in GitHub Desktop.
Save sigmike/470015 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
create user and database
CREATE USER '<username>'@'localhost' IDENTIFIED BY '<password>';
CREATE DATABASE IF NOT EXISTS `<database_name>`;
GRANT ALL PRIVILEGES ON `<database_name>`.* TO '<username>'@'localhost';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment