CREATE USER 'user'@'%' IDENTIFIED BY 'pass'; GRANT ALL PRIVILEGES ON db.tblTO 'user'@'%'; FLUSH PRIVILEGES;