CREATE USER 'mystuff'@'localhost' IDENTIFIED BY 'stuffy';

GRANT USAGE ON * . * TO 'mystuff'@'localhost' IDENTIFIED BY 'stuffy' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

CREATE DATABASE IF NOT EXISTS `stuff` ;

GRANT ALL PRIVILEGES ON `stuff`.* TO 'mystuff'@'localhost';

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

USE `stuff`;

CREATE TABLE `religions` (
  `religion` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `adherents` int(11) NOT NULL,
  PRIMARY KEY (`religion`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `religions` (`religion`, `adherents`) VALUES 
('Roman Catholic', 1117759185),
('Hindu', 856690863),
('Buddhist', 381610979),
('Protestant', 372586395),
('Orthodox', 221746920),
('Anglican', 81865869),
('Sikh', 25139912),
('Jewish', 14826102);