MySQL database (moodle) and SQL-user permitions, need help!!

MySQL database (moodle) and SQL-user permitions, need help!!

by Saso Skocir -
Number of replies: 0

Hi ,

I need help on clearing some things arround premitions for user created for SQL database named moodle before starting 1st inatll of moodle.

I cannot finde info on permitions that should be granted to SQLuser on Administration privileges.

I know that from DATA privil. should be checked:
SELECT,INSERT,UPDATE,DELETE

in STRUCTURE privil. those are:
CREATE,CREATE TEMPORARY TABLES, DROP,INDEX,ALTER

but what about ADMINISTRATION privileges ???

such as GRAND, SUPER,PROCESS, RELOAD, SHUTDOWN ...
are those privileges aneccessary to be set or
I can leave foe SQL user GRANT on NO

Please for help
I created one SQL user with those third priviliges and one without mešano


.-..and now the files copied onto server is almost finished, and I will have to make an decision on which user to state in install of moodle, where stating the user to acces the database moodle to successful complete the install.

waiting for na answer
Saso
Average of ratings: -