[Koha-bugs] [Bug 22128] koha-remove fails mysql ERROR 1133 (42000) at line 2: Can't find any matching row in the user table

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

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

Rudolf Byker <rudolfbyker at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |Needs Signoff
           Assignee|koha-bugs at lists.koha-commun |rudolfbyker at gmail.com
                   |ity.org                     |

--- Comment #1 from Rudolf Byker <rudolfbyker at gmail.com> ---
Created attachment 89528
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=89528&action=edit
Use "DROP USER IF EXISTS" instead of "GRANT USAGE" before "DROP USER".

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.

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