As of the 20141129-001 release of SimpleRisk, a check was added to ensure that the database user for SimpleRisk has the necessary privileges for the upgrade process. This message indicates that your database user is missing the necessary privileges. To fix it, run the command grant select,insert,update,alter,delete,create,drop on simplerisk.* to 'simplerisk'@'localhost’; as the root user on your MySQL database where the first "simplerisk" is the name of the database and the second is the name of the user. Then, run the command flush privileges; for the change to take effect. Finally, re-run the upgrade script and this message should go away.
Why do I get a message saying one of the necessary grants was missing while trying to upgrade SimpleRisk? Print
Modified on: Wed, Aug 19, 2015 at 11:58 PM
Did you find it helpful? Yes No
Send feedbackSorry we couldn't be helpful. Help us improve this article with your feedback.