From b8bf14b7deb6fe74ac2f39737a84594e07c7d09c 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 Content-Type: text/plain; charset=utf-8 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). --- debian/scripts/koha-create | 2 ++ 1 file changed, 2 insertions(+) diff --git a/debian/scripts/koha-create b/debian/scripts/koha-create index a9fe29c..2636675 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