feat: support mysql2 v1

[nozik]

Which problem is this PR solving?

• Current instrumentation is configured to support mysql2 version 2.x. It can support version 1.x as well.

Short description of the changes

• Adapt the configuration to support v1.x as well. Make sure all the tests run successfully.

Checklist

• Ran npm run test-all-versions for the edited package(s) on the latest commit if applicable.

[codecov]

Codecov Report

Merging #908 (0cdc592) into main (1f68004) will increase coverage by 0.16%.
The diff coverage is n/a.

@@            Coverage Diff             @@
##             main     #908      +/-   ##
==========================================
+ Coverage   95.91%   96.07%   +0.16%     
==========================================
  Files          13       16       +3     
  Lines         856      994     +138     
  Branches      178      202      +24     
==========================================
+ Hits          821      955     +134     
- Misses         35       39       +4     

Impacted Files	Coverage Δ
...etry-instrumentation-mysql2/src/instrumentation.ts	95.00% <ø> (ø)
...tapackages/auto-instrumentations-node/src/utils.ts	97.87% <0.00%> (ø)
.../opentelemetry-instrumentation-mysql2/src/utils.ts	100.00% <0.00%> (ø)