Skip to content

Instantly share code, notes, and snippets.

@octavian-nita

octavian-nita/create-db.my.sql

Last active August 29, 2015 14:01
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save octavian-nita/95372f22b70a12183b28 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save octavian-nita/95372f22b70a12183b28 to your computer and use it in GitHub Desktop.
Download ZIP
Create MySQL database and user and grant rights (precedes many tool installations like WordPress, Koken, etc.)
Raw
create-db.my.sql
CREATE DATABASE IF NOT EXISTS kabuki DEFAULT CHARACTER SET = 'utf8' DEFAULT COLLATE 'utf8_general_ci';
GRANT USAGE ON *.* TO 'koken'@'localhost' IDENTIFIED BY 'Midori1981';
GRANT ALL PRIVILEGES ON kabuki.* TO 'koken'@'localhost';
FLUSH PRIVILEGES;
@octavian-nita
Copy link
Copy Markdown
Author

octavian-nita commented May 16, 2014

see http://www.bluepiccadilly.com/2011/12/creating-mysql-database-and-user-command-line-and-bash-script-automate-process for simple explanation

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment