Skip to content

Instantly share code, notes, and snippets.

@anytizer

anytizer/Creating Database and User.sql

Last active August 29, 2015 13:56
Show Gist options
  • Save anytizer/9151024 to your computer and use it in GitHub Desktop.
Save anytizer/9151024 to your computer and use it in GitHub Desktop.
Download ZIP
Creating Database and User
Raw
Creating Database and User.sql
CREATE DATABASE PREFIX_DATABASE CHARACTER SET utf8 COLLATE utf8_general_ci;
GRANT ALL ON PREFIX_DATABASE.* TO 'PREFIX_USERNAME'@'%' IDENTIFIED BY 'RANDOM_PASSWORD';
GRANT ALL ON PREFIX_DATABASE.* TO 'PREFIX_USERNAME'@'localhost' IDENTIFIED BY 'RANDOM_PASSWORD';
-- mysql -hlocalhost -uPREFIX_USERNAME -pRANDOM_PASSWORD PREFIX_DATABASE
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment