GRANT ALL PRIVILEGES on db.table to user@'%'; FLUSH PRIVILEGES; GRANT SELECT,INSERT,UPDATE,DELETE ON *.* TO 'user'@'localhost' IDENTIFIED BY 'pwd' WITH GRANT OPTION GRANT SELECT,INSERT,UPDATE,DELETE ON *.* TO 'user'@'%' IDENTIFIED BY 'pwd' WITH GRANT OPTION; GRANT SELECT,INSERT,UPDATE,DELETE ON $DB.* TO '$USER'@'localhost' IDENTIFIED BY '$PWD' WITH GRANT OPTION;