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)
committerMartin Renvoize <martin.renvoize@ptfs-europe.com>
Fri, 28 Jun 2019 13:27:55 +0000 (14:27 +0100)
commite9bb407f62a208d42aefb03d16decd87bae228e7
tree2c45b150ae275716bb12f52dbcf53b3f7aca1ae5
parent4dcf416dc9547fd28e6ed846d08d6bbecb144552
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>
debian/scripts/koha-remove