Databases: MySQL Permissions

Databases: MySQL Permissions

by MEH FEH -
Number of replies: 1
Our website was recently hacked and we've had to lock down the database.  We're sorting through it right now, but I need to know what MySQL db permissions are needed for Moodle.  Does anyone have a rundown of this?
Average of ratings: -
In reply to MEH FEH

Re: Databases: MySQL Permissions

by Martin Dougiamas -
Picture of Core developers Picture of Documentation writers Picture of Moodle HQ Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers
Create a specific user for each database you have, but the permissions for the Moodle user pretty much need to allow full control over that Moodle database, including adding and dropping tables, altering tables etc.