From 0241ad5b5955069e6da8169cb7be0b35cfe6d28c Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Thu, 27 Oct 2016 14:15:57 +0000 Subject: [PATCH] [PASSED QA] Bug 17513: Create GRANT for user@localhost in koha-create See the bug description for the details. Test plan: Use this script to create a new koha installation, using MariaDB You should not display "user koha_kohadev doesn't have enough privilege on database koha_kohadev " Signed-off-by: Martin Renvoize --- debian/scripts/koha-create | 2 ++ 1 file changed, 2 insertions(+) diff --git a/debian/scripts/koha-create b/debian/scripts/koha-create index e416c8c..29e8fb6 100755 --- a/debian/scripts/koha-create +++ b/debian/scripts/koha-create @@ -661,6 +661,7 @@ CREATE DATABASE \`$mysqldb\`; CREATE USER \`$mysqluser\`@'$mysql_hostname' IDENTIFIED BY '$mysqlpwd'; CREATE USER \`$mysqluser\`@'%' IDENTIFIED BY '$mysqlpwd'; GRANT ALL PRIVILEGES ON \`$mysqldb\`.* TO \`$mysqluser\`; +GRANT ALL PRIVILEGES ON \`$mysqldb\`.* TO \`$mysqluser\`@'$mysql_hostname'; FLUSH PRIVILEGES; eof fi #` @@ -671,6 +672,7 @@ eof CREATE USER \`$mysqluser\`@'$mysql_hostname' IDENTIFIED BY '$mysqlpwd'; CREATE USER \`$mysqluser\`@'%' IDENTIFIED BY '$mysqlpwd'; GRANT ALL PRIVILEGES ON \`$mysqldb\`.* TO \`$mysqluser\`; +GRANT ALL PRIVILEGES ON \`$mysqldb\`.* TO \`$mysqluser\`@'$mysql_hostname'; FLUSH PRIVILEGES; eof fi #` -- 2.1.4