Announcement

Collapse
No announcement yet.

MySQL Database Permissions

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

  • 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.

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

    Comment


    • #3
      Thanks

      Comment

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