Refactor Internal.Client to use mysql-simple like API.

The connect, close, and ConnectInfo API mirrors what is found in
popular libraries such as mysql-simple and postgresql-simple.