From 564f86dd981f0403401539d17614da1423abb308 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Thu, 27 Oct 2016 14:15:57 +0000 Subject: [PATCH] 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 Signed-off-by: Marcel de Rooy Confirm that this still works (with MySQL). Signed-off-by: Kyle M Hall (cherry picked from commit 474a369fc03f992971c8af11c910f778e34ac9b9) Signed-off-by: Julian Maurice --- debian/scripts/koha-create | 2 ++ 1 file changed, 2 insertions(+) diff --git a/debian/scripts/koha-create b/debian/scripts/koha-create index 2a6c87dddd..bd90d1169e 100755 --- a/debian/scripts/koha-create +++ b/debian/scripts/koha-create @@ -586,6 +586,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 #` @@ -596,6 +597,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.39.5