database connection

Set cn = New ADODB.CONNECTION

Set cn = New ADODB.CONNECTION

cn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};" _
& "SERVER=192.168.1.229;" _
& "DATABASE=ssmpc_database;" _
& "UID=root;PWD=ssmpc; OPTION=3"
cn.Open

on the computer that i am working on, the connection is working.
but when i try to put the vb program on another computer
message appears ("cant connect to mysql server on 192.168.1.229")

how to access mysql connection remotely?