MySQL create database user and grants privileges with a single command

user.grant.sql

-- create database user and grant privileges with a single command

GRANT ALL PRIVILEGES
  ON TABLE <database>.*
  TO <user>
  IDENTIFIED BY <password>;
  
SHOW GRANTS FOR <user>;
-- output:    GRANT ALL PRIVILEGES ON `<database>`.* TO '<user>'@'%'
-- % is the default host for the user (ie. IP address or hostname where the user connects from)

-- OR:
-- CREATE USER <user> IDENTIFIED BY <password>;
-- GRANT ALL PRIVILEGES ON <database>.* TO '<user>'@'%';

-- qv. https://dev.mysql.com/doc/refman/5.6/en/grant.html