Skip to content

Instantly share code, notes, and snippets.

@ovidiuch

ovidiuch/create_db.sql

Created March 31, 2012 11:21
Show Gist options
  • Save ovidiuch/2262374 to your computer and use it in GitHub Desktop.
Save ovidiuch/2262374 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL utf8 db and user create
Raw
create_db.sql
CREATE DATABASE dbname DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
GRANT SELECT, INSERT, UPDATE, DELETE ON dbname.* TO 'usr'@'localhost' IDENTIFIED BY 'passwd';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment