MySQL user privileges

Permalink 1 user found helpful
I'm seeing conflicting reports on this and just wanted to get the community's opinion.
In the c5 Beginner's Guide by Remo, it states that MySQL users need the following privileges:
INSERT, SELECT, UPDATE, DELETE, CREATE, DROP, ALTER
.
However, on the Basic Setup info on the c5 site found athttp://www.concrete5.org/documentation/installation/installing_conc...

There it says to create a user with full permissions.
So which one is correct? I'm keeping security in mind, so if I don't actually need all privileges, then why turn them on all?
Looking forward to the feedback and insights!

PatrickHenry
View Replies:
mlocati replied on at Permalink Reply
mlocati
IMHO Remo's suggestions are correct.
Maybe the concrete5 core team asks for full rights to feel free when implementing new features, but if I'm not wrong the rights described by Remo are enough.