MySQL database and user for phpBB 3.3.9

[Diggy69]

I'm looking to deploy phpBB v3.3.9 with MySQL as the database backend.

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.

[Mick]

What kind of hosting do you have, with what host?

FWIW - database creation and management is a server side role.

[Diggy69]

I am a systems administrator and phpBB will be self-hosted on a Rocky Linux 9 virtual machine.

[Mick]

Just create a database (not a phpBB function) and connect to it with phpBB via installation, you shouldn’t have to do any more than that.

Do I need to specify anything

The database collation reported by phpMyAdmin isn't too important. phpBB will set the connection properties as needed when it connects. As long as the tables show the correct collations and character sets, it's fine.