[Koha-bugs] [Bug 17237] Stop koha-create from creating MySQL users without host restriction

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17237

--- Comment #4 from M. Tompsett <mtompset at hotmail.com> ---
Created attachment 74850
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=74850&action=edit
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 '%'

-- 
You are receiving this mail because:
You are watching all bug changes.