Check out the LimeSurvey source code on GitHub!
Welcome, Guest
Username: Password:

TOPIC: What MySQL user privileges are required LimeSurvey to run?

What MySQL user privileges are required LimeSurvey to run? 3 years 6 months ago #91795

  • Sweden
  • Sweden's Avatar
  • Offline
  • Senior Lime
  • Posts: 78
  • Thank you received: 1
  • Karma: 2
Hi,

I want to increase security and only give specific privileges to my limesurvey MySQL user. Right now it is set to "GRANT ALL PRIVILEGES ON" - I would like to change that, if possible.
What privileges are required as a minimum by the limesurvey to run without problems?

Thanks
Last Edit: 3 years 5 months ago by c_schmitz.
The administrator has disabled public write access.

What MySQL user privileges are required by the limesurvey to run? 3 years 5 months ago #91800

  • c_schmitz
  • c_schmitz's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 999
  • Thank you received: 135
  • Karma: 97
Insert/update/delete/create/alter/drop/index should be the minimum permissions.
Best regards

Carsten Schmitz
LimeSurvey project leader
The administrator has disabled public write access.
The following user(s) said Thank You: Sweden

What MySQL user privileges are required by the limesurvey to run? 3 years 5 months ago #91814

  • Sweden
  • Sweden's Avatar
  • Offline
  • Senior Lime
  • Posts: 78
  • Thank you received: 1
  • Karma: 2
Thanks - I try that. Perhaps you know the answer to my other question found in this thread (link) - that issue seems to be a rather big security risk if left unfixed and may affect all old and new installations of LimeSurvey.
Last Edit: 3 years 5 months ago by Sweden.
The administrator has disabled public write access.

What MySQL user privileges are required by the limesurvey to run? 3 years 5 months ago #91822

  • Sweden
  • Sweden's Avatar
  • Offline
  • Senior Lime
  • Posts: 78
  • Thank you received: 1
  • Karma: 2
c_schmitz wrote:
Insert/update/delete/create/alter/drop/index should be the minimum permissions.

Hmmm.... it doesn't work. Now I get an "Internal Server Error" when I try to log into admin panel. Something about settings_global that can't be found...
I tried to revert to "all privileges", and then it works again but that isn't a solution.

What else do I need to choose? Here are all the options:

ALTER, CREATE ROUTINE, CREATE VIEW, DROP, INDEX, LOCK TABLES, SELECT, TRIGGER, CREATE, CREATE TEMPORARY TABLES, DELETE, EXECUTE, INSERT, REFERENCES, SHOW VIEW, UPDATE
Last Edit: 3 years 5 months ago by Sweden.
The administrator has disabled public write access.

What MySQL user privileges are required by the limesurvey to run? 3 years 5 months ago #92077

  • c_schmitz
  • c_schmitz's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 999
  • Thank you received: 135
  • Karma: 97
Add 'Select', too.
Best regards

Carsten Schmitz
LimeSurvey project leader
The administrator has disabled public write access.

What MySQL user privileges are required by the limesurvey to run? 3 years 5 months ago #92089

  • Sweden
  • Sweden's Avatar
  • Offline
  • Senior Lime
  • Posts: 78
  • Thank you received: 1
  • Karma: 2
Thanks - That seems to work :)
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.236 seconds
Imprint                   Data Protection Statement                  Revocation information and revocation form