use mysql;
GRANT ALL PRIVILEGES ON *.* TO 'foo'@'%' IDENTIFIED BY 'foo' WITH GRANT OPTION;
FLUSH PRIVILEGES;
CREATE DATABASE IF NOT EXISTS testdb;
use testdb;
CREATE TABLE IF NOT EXISTS users (
email VARCHAR(120),
password VARCHAR(120),
username VARCHAR(120) PRIMARY KEY,
notify VARCHAR(120)
);
insert into users (email,username,notify) values ("bill@microsoft.com","bill","yes");
insert into users (email,username,notify) values ("gate@microsoft.com","gate","yes");