From 291c250dcfe23c046f3b5df419b8819fb92cbcf3 Mon Sep 17 00:00:00 2001 From: Mark Tompsett Date: Wed, 25 Apr 2018 16:44:03 +0000 Subject: [PATCH] Bug 17237: Remove CREATE USER 'user'@'%' line Having a 'user'@'%' line decreases database security. Bug 16690 closes the need for such a line, and this bug removes the use of it. TEST PLAN --------- While this depends on 16690, it is not required for testing. On a kohadev box: sudo koha-create --create-db test_17237_a git bz apply 17237 sudo perl ~/misc4dev/cp_debian_files.pl restart_all sudo systemctl daemon-reload sudo koha-create --create_db test_17237_b sudo mysql -u root SELECT user,host from mysql.user; -- test_17237_a will have two entries, one being '%' -- test_17237_b will only have one entry, not '%' Signed-off-by: Martin Renvoize Signed-off-by: Josef Moravec Signed-off-by: Nick Clemens (cherry picked from commit 1e856e7e7316749f59cb4e721e352b0a60237def) Signed-off-by: Martin Renvoize --- debian/scripts/koha-create | 2 -- 1 file changed, 2 deletions(-) diff --git a/debian/scripts/koha-create b/debian/scripts/koha-create index 8cdc219e8b..f49a7310c8 100755 --- a/debian/scripts/koha-create +++ b/debian/scripts/koha-create @@ -726,8 +726,6 @@ then mysql $MYSQL_OPTIONS <