Required Mysql Privileges For Blesta

[L3Y]

Hi,

 

What are the required privileges to run blesta with mysql if i do not want to grant all privileges on the db?

 

The ones i was using were working fine, until i upgraded to the  latest version of the database server  : then i got a blank page everywhere in Blesta until i temporary granted all privileges on the db. I must be missing something.

 

Thank you,

 

Carl

 

Edit : seems like if i switch them back to the original ones, it's working now.  I am going to read a little on this upgrade    I'll leave this open, just curious to see if my privileges are correct or not.

[Michael]

Everyone I know gives full permissions. If you trust the software / script you don't need to worry as certain features require certain commands.

[Paul]

Blesta needs full access to its database. During upgrades or plugin installation, it may need to alter the database. It shouldn't need permissions to server administration type of privileges though like CREATE USER for example.

 

https://dev.mysql.com/doc/refman/5.1/en/privileges-provided.html

 

Cody or Tyson may be able to offer more details on exactly what privileges are required, but I think you're safe with everything on that list above ALTER ROUTINE.