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");