Connection#changeUser is not a method about node-mysql2

[sidorares]

It's a command in mysql protocol and I really don't want to implement it. You can always change database with sql query: query('use someNewDb', cb). I don't mind to have changeUser as a wrapper to query - would it solve your problem? Do you want to create PR with this change?

[seanmonstar]

I wouldn't worry how it's actually implemented, wrapper or protocol. I was just trying to drop in mysql2 to compare the speeds in our test framework, and hit this error :)

[sidorares]

I agree that if I advertise it to be drop in replacement I need to add changeUser. Will do as a wrapper :)

[doug65536]

I believe changeUser is also used to reset a connection fully before returning it to a pool (ends all transactions, etc.) Does the connection pooling functionality already do that?

[sidorares]

@doug65536 No, not for node-mysql2 currently. Might be not a good idea in some cases (I don't want to loose all prepared statements when I return connection to pool)

[sidorares]

next in my queue. link to protocol doco: http://dev.mysql.com/doc/internals/en/com-change-user.html

[sidorares]

also make sure that code from mysqljs/mysql#806 is backported

[sidorares]

and mysqljs/mysql@5e43c5c as well ( or better, pull all latest Pool / PoolCluster changes from node-mysql )

[sidorares]

landed, soon to be published as 0.15.0