From 2c4a3cb7e0b767c3a7ef8887e18541044ae1cff2 Mon Sep 17 00:00:00 2001 From: Louis-Philippe Véronneau Date: Tue, 13 Feb 2018 12:18:48 -0500 Subject: add required SQL permissions to database installation procedure --- doc/en_US/mysql-configuration.markdown | 6 ++++++ 1 file changed, 6 insertions(+) diff --git a/doc/en_US/mysql-configuration.markdown b/doc/en_US/mysql-configuration.markdown index 27d5141d..e2516e8c 100644 --- a/doc/en_US/mysql-configuration.markdown +++ b/doc/en_US/mysql-configuration.markdown @@ -24,6 +24,12 @@ By example, you can do that with the command line mysql client: CREATE DATABASE kanboard; ``` +You can then assign the required permissions on the database: + +```sql +GRANT ALTER, CREATE, DELETE, DROP, INDEX, INSERT, REFERENCES, SELECT, UPDATE ON kanboard.* TO 'USERNAME'@'HOST' IDENTIFIED BY 'PASSWORD'; +``` + ### Create a config file The file `config.php` should contains those values: -- cgit v1.2.3