dialects.mysql.connection-manager: Use `connection._protocol._ended` state on $validate

Change validation method, as discussed on #2381
Good to know the current code wasn't any better.
Why we should really have tests for this sort of thing too, but it might be hard to mock.