Create user and privileges to DB in MySQL VIA script

I need to create a script that can cre开发者_如何学JAVAate a user/password and grant then certain privileges on a local DB.

Thanks in advance!

-Sol

GRANT ALL PRIVILEGES ON DB.* TO 'user'@'%' IDENTIFIED BY 'password';