CREATE USER 'foobaz'@'%' IDENTIFIED BY 'foopassword'; CREATE DATABASE IF NOT EXISTS `foobaz` ; GRANT ALL PRIVILEGES ON foobaz.* TO foobaz@localhost IDENTIFIED BY 'foopassword'; ;superuser CREATE USER 'user'@'%' IDENTIFIED BY 'pass'; GRANT ALL PRIVILEGES ON *.* TO 'user'@'%' WITH GRANT OPTION; CREATE USER 'user'@'localhost' IDENTIFIED BY 'pass'; GRANT ALL PRIVILEGES ON *.* TO 'user'@'%' WITH GRANT OPTION; FLUSH PRIVILEGES;