Full or Limited Database Privileges

[eluser]digity[/eluser]
For the database config, what kind of privileges should the mysql user have? Limited privileges (i.e., SELECT, INSERT, UPDATE, etc.) or root or near-root privileges?

[eluser]cahva[/eluser]
Always limited privileges to the database(s) that it uses.

[eluser]digity[/eluser]
So does that mean my app built on CI should never need to DELETE, DROP, CREATE, ALTER, etc.?

[eluser]wh1tel1te[/eluser]
You should only give your user enough privileges to do its job, and nothing more. This usually is SELECT, UPDATE and DELETE. If you find you need more privileges later on, just grant it.

[eluser]digity[/eluser]
Thanks you two!