MySQL database and user for CPG 1.6

[netboy]

I'm looking to deploy CPG v1.6 in a self-hosted environment.  I am the systems administrator.

With regards to creating the database and user:

Do I need to specify anything, such as collation or anything else, when issuing the CREATE DATABASE statement?
Please provide the complete mysql CREATE DATABASE statement.

What privileges to the database do I need to GRANT to the db user? I would like to grant only the minimum required privileges.
Please provide the necessary GRANT statement(s) to give required access to the database.

And yes, I did search the installation documentation for this information without finding answers.

In advance, thank you for your help.