forum.coppermine-gallery.net

Support => cpg1.6.x Support => cpg1.6 install => Topic started by: netboy on January 24, 2023, 11:19:28 pm

Title: MySQL database and user for CPG 1.6
Post by: netboy on January 24, 2023, 11:19:28 pm
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.