I'm going to be doing some complicated maintenance on our MySQL servers and I'd like to keep users out during the work. I'd prefer not to drop and re-create all of the user accounts, but that's the only solution I've come up with so far. Hmm.. Refusing network connections would work as well, as the maintenance will be done via an os-local mysql CLI. I'd prefer to not have to stop and re-start the server, but that's not impossible.
What are best practices here?
Thanks in advance, Brad