Create user and privileges to DB in MySQL VIA script

Question

I need to create a script that can create a user/password and grant then certain privileges on a local DB.

Thanks in advance!

-Sol

Answer 1

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