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