1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Database naming convention

Discussion in 'XenForo Questions and Support' started by Ryan Kent, Feb 15, 2011.

  1. Ryan Kent

    Ryan Kent Well-Known Member

    I realize we can name our db anything but was wondering if there was any suggested or commonly used name....Forums? XenForo? XF?
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    It's just down to personal preference really.
    There isn't a convention or suggested naming system to use.
     
  3. Kier

    Kier XenForo Developer Staff Member

    I've seen forum, xenforo, {sitename}_forums, {sitename}_xenforo, xf_{sitename}... there's really no rules at all, just use what makes sense to you, though I'd recommend using only lowercase letters, numbers and underscores.
     
  4. Ryan Kent

    Ryan Kent Well-Known Member

    thanks!

    One other db question plz. What permissions do you recommend on the account used by XenForo? I generally prefer to provide the least permissions possible.
     
  5. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Probably just full access. That's what I use. I haven't seen minimum MySQL permissions listed anywhere.

    Normally you would create a separate MySQL user with access only to the xenForo database. The user will have full access but only to that one database.
     
    Kier likes this.

Share This Page