3

Due to an error in my code I got my PC blocked from an active production DB (too many connection errors).
The error calls for me to use 'flush hosts' in order to reset the host cache.

Are there any risks involved in doing so? Will active connections be terminated? Does it do anything beyond just flushing the cache?

Improve this question
2
  • No harm. No connection termination. The cache is used only when clients are trying to connect; apparently something is out-of-date in the cache.
    – Rick James
    Commented Mar 23, 2015 at 17:24
  • @RickJames by now I have performed the operation. I could not see any side effects. If you write that comment as an answer, I will accept it.
    – Michael K
    Commented Mar 24, 2015 at 10:55

1 Answer 1

Reset to default
3

No harm. No connection termination. The cache is used only when clients are trying to connect; apparently something is out-of-date in the cache.

(Follup: The OP tried it and found no side effects.)

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.