Bug: hardcoded dialect/driver parameter in connection url in mysql container

[nightblure]

Describe the bug

I find it strange that the dialect or driver parameter is hardcoded here (look screenshot below), because today there are many different methods and drivers for connecting to mysql. If I use something other than pymysql, I get the wrong connection address from the get_connection_url method.

Code:

Possible solution

1. Remove this hardcoded line and leave only mysql://...;
2. Allow you to pass an optional dialect or driver parameter to the get_connection_url function or the MySqlContainer class initializer. If its value is non-empty, then in the get_connection_url method it will be inserted into the right place in the connection string

---

To Reproduce

• just see to current code (testcontainers 4.8.2)

Runtime environment Looks optional for this issue

[nightblure]

If this solution works, I could do it