MySQL database and user for phpBB 3.3.9

Get help with installation and running phpBB 3.3.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
Diggy69
Registered User
Posts: 3
Joined: Tue Jan 24, 2023 12:08 am

MySQL database and user for phpBB 3.3.9

Post by 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.
User avatar
Mick
Support Team Member
Support Team Member
Posts: 24963
Joined: Fri Aug 29, 2008 9:49 am
Contact:

Re: MySQL database and user for phpBB 3.3.9

Post by Mick »

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

FWIW - database creation and management is a server side role.
  • "The more connected we get the more alone we become" - Kyle Broflovski©
  • "The good news is hell is just the product of a morbid human imagination.
    The bad news is, whatever humans can imagine, they can usually create.
    " - Harmony Cobel
Diggy69
Registered User
Posts: 3
Joined: Tue Jan 24, 2023 12:08 am

Re: MySQL database and user for phpBB 3.3.9

Post by Diggy69 »

I am a systems administrator and phpBB will be self-hosted on a Rocky Linux 9 virtual machine.
User avatar
Mick
Support Team Member
Support Team Member
Posts: 24963
Joined: Fri Aug 29, 2008 9:49 am
Contact:

Re: MySQL database and user for phpBB 3.3.9

Post by 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.
Diggy69 wrote: Tue Jan 24, 2023 12:19 amDo I need to specify anything
Noxwizard wrote: Mon Sep 07, 2020 4:39 pm 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.
  • "The more connected we get the more alone we become" - Kyle Broflovski©
  • "The good news is hell is just the product of a morbid human imagination.
    The bad news is, whatever humans can imagine, they can usually create.
    " - Harmony Cobel
Post Reply

Return to “[3.3.x] Support Forum”