Bug 22128: Use DROP USER IF EXISTS instead of GRANT USAGE before DROP USAGE
authorRudolf Byker <rudolfbyker@gmail.com>
Fri, 24 May 2019 18:25:45 +0000 (13:25 -0500)
committerFridolin Somers <fridolin.somers@biblibre.com>
Thu, 25 Jul 2019 11:43:19 +0000 (13:43 +0200)
commitefab6445010254973468314c90b544e4f5318684
treed5e2096dd5f57d71dffce8c0d4434011e3adfd46
parent0dd58132e64be0d146d1809967a41730965c5d62
Bug 22128: Use DROP USER IF EXISTS instead of GRANT USAGE before DROP USAGE

MySQL 5.7 is old, and the latest versions fail on "GRANT USAGE" if the
user does not exist. "DROP USER IF EXISTS" has been with us since 5.7,
so all users should have it by now. This patch fixes the issue.

To test:

Try to koha_remove a site, and if it works with no errors, all good!

Signed-off-by: Mark Tompsett <mtompset@hotmail.com>
Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
(cherry picked from commit e9bb407f62a208d42aefb03d16decd87bae228e7)
Signed-off-by: Fridolin Somers <fridolin.somers@biblibre.com>
debian/scripts/koha-remove