Ok. i give up trying to convince you to use ADODB. here is what i thinking.
as you may or may not know mysql by default does not allow remote connectins to databases. by default it allows only localhost (127.0.0.1) or (any ip that is your local machine) to connect. when you create a user you must explicitly grant access to that user. So however you create your user check to ensure you have granted that user remote access.
i normally do
"grant all on DB to user@ip to username identified by password;"
offcourse i has console acces to the server to do this