yet it ALSO appears connected to others.

No, it doesn't. You just connect to one server, and pass it the SQL to execute.

It makes me wonder why I have to specify a database when making a connection?

If you don't specify the server, how would it know to which server to connect and to send the SQL?