You’re encountering a connection error when trying to use SQLAlchemy with mysql-connector-python in a Python script. The script aims to upload CSV data to an existing MySQL database. However, during the configuration of the SQLAlchemy engine, an InterfaceError occurs with the message:

(mysql.connector.errors.InterfaceError) 2003: Can’t connect to MySQL server on ‘%-.100s:%u’ (%s) (Warning: %u format: a real number is required, not str)

Questions:

What could be causing the format-related error in the connection string?
How can I correctly format the connection string to avoid this issue?

What I Tried:

Verified MySQL Server Status:

Ensured that the MySQL server is up and running and accessible from the machine where the script is being executed.
Checked Connection String Format:

Reviewed and confirmed that the connection string format used in the script is correctly structured and that all placeholders for database credentials and connection details are correctly replaced.
Run the Script:

Executed the Python script that attempts to configure the SQLAlchemy engine and upload CSV data to the MySQL database.
What I Was Expecting:

Successful Connection:

I expected the script to successfully connect to the MySQL server using the provided credentials and connection details.
CSV Data Upload:

Once connected, I anticipated that the script would read the CSV file and successfully upload its contents to the specified MySQL database, creating or replacing a table based on the CSV file’s name.
Error-Free Execution:

Expected that the script would run without errors related to connection formatting or server access, allowing smooth execution of the data upload process.