Announcement

Collapse
No announcement yet.

Minimum privlege set for vBulletin mysql user

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Minimum privlege set for vBulletin mysql user

    I am setting up my vBulletin instance to use a different user than the 'root' mysql user, and I need to know the minimum set of rights that I need to grant to that user.

  • #2
    It has to have FULL permissions.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      Can it be restricted by db?

      i.e.
      With the mysql server and the vBulletin instance on the same host, is it reasonable to do the following,:

      in config.php

      Code:
      $config['Database']['dbname'] = 'forum';
      $config['MasterServer']['username'] = 'forum';
      $config['MasterServer']['password'] = 'somepassword';
      in mysql,

      Code:
      mysql> CREATE DATABASE forum;
      mysql> GRANT ALL PRIVILEGES ON forum.* TO 'forum'@'localhost' 
          IDENTIFIED BY 'somepassword' WITH GRANT OPTION;
      The goal here is to minimize the damage if my host is compromised and an unauthorized user gains access to config.php which looks as though it must contain a plain text password.

      Unfortunately, I don't know jack about SQL or mysql.
      Last edited by babel17; Fri 16 Jan '09, 2:19pm.

      Comment


      • #4
        ok, got it now.

        Found this post:
        http://www.vbulletin.com/forum/showthread.php?t=208036

        Comment

        widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
        Working...
        X