Skip to content

Instantly share code, notes, and snippets.

@iwinux

iwinux/setup.sql

Created September 20, 2011 04:34
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save iwinux/1228336 to your computer and use it in GitHub Desktop.
Save iwinux/1228336 to your computer and use it in GitHub Desktop.
Download ZIP
Set up a database in MySQL
Raw
setup.sql
CREATE DATABASE `databasename` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE USER 'user'@'localhost' IDENTIFIED BY 'mypass';
GRANT ALL ON databasename.* TO 'user'@'localhost';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment