Hey everybody, here is an interesting situation.
In a few scripts, I must interact with MySQL's mysql database so I can change user information. However, since there is no supported API to simply change user on the current connection, another connection to the server with a different username and password has to be made.
After the connection has been made, it is treated as the active connection. I then go about and make changes to the system information and close the latest connection.
However, once I close the latest connection, the original connection that I had open is not set as the active connection! Am I mistaken, or should active status be returned to any connections still open? How do I set a connection to be the active connection?
