User300755119 posted
Solved.
I posed the solution for anyone in my situation: I had selected the wrong drivers.
I went to the windows control panel, looking for "ODBC data source administrator (64bit)" and I realized that the drivers installed for mysql are MySQL ODBC 8.0 ANSI Driver
Therefore the correct string is:
conn.Open "DRIVER={MySQL ODBC 8.0 ANSI Driver};Server=remotemysql.com;Database=H8HCs8jWdg;user=H8HCs8jWdg;PWD=********;"