Is it possible to change the selected database with the Mysql2 gem?

Question

I'd like to change which database the Mysql2::Client is using (e.g. the same as typing "use X" in the mysql command-line) without having to establish a new connection to the DB server. Is this possible? How?

Accepted Answer

Use `select_db`

```
db = Mysql2::Client.new
db.select_db('test')
```

Is it possible to change the selected database with the Mysql2 gem?

Solution

Problem