MySQL Database Permissions

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • LetMeWinSheesh
    Member
    • Nov 2006
    • 35
    • 3.6.x

    MySQL Database Permissions

    Hi

    I just uploaded my forum to my site. During the install process I had to setup my own database and user and permissions. I don't know much about MySQL so on my user I enabled all the available permissions to make sure the install went without issues.

    Maybe for security reasons I shouldn't have them all enabled.

    Which of the following permissions are required to run my forum, and which should I turn back off?
    1. grant
    2. lock tables
    3. drop
    4. create temporary tables
    5. update
    6. create
    7. alter
    8. index
    9. select
    10. references
    11. insert
    12. delete
    Thank You.
  • Zachery
    Former vBulletin Support
    • Jul 2002
    • 59097

    #2
    You can remove grant, otherwise the rest are fairly nessary.

    Comment

    • LetMeWinSheesh
      Member
      • Nov 2006
      • 35
      • 3.6.x

      #3
      Thanks

      Comment

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