Add `db.collection.name` to mysql-based instrumentation libraries

[hannahramadan]

The db.collection.name attribute is conditionally required for Database spans.

Update mysql2 and trilogy instrumentations to emit this attribute.

[github-actions]

👋 This issue has been marked as stale because it has been open with no activity. You can: comment on the issue or remove the stale label to hold stale off for a while, add the keep label to hold stale off permanently, or do nothing. If you do nothing this issue will be closed eventually by the stale bot.

[hannahramadan]

Issue is being worked on: #1109