remote mysql

[hinditut]

hi everyone

let me know how to connect remote sql database on mypc vb6.0 software

i use in mycode

server: johnny.heliohost.org

db:mysqldatabase

username:dbusername

password:dbpassword

port:3306

 

Set cn = New ADODB.Connection

                cn.CursorLocation = adUseClient

                cn.Open "DRIVER={MySQL ODBC 3.51 Driver};SERVER=" & isServer & ";DATABASE=" & isDatabase & ";UID=" & isUsername & ";PWD=" & isPASSWORD & ";PORT=" & isPORT & ";OPTION=3"

 

i am also following in my code but did't get success every get response access denied for user 

please tell me anyone how to resolve and what i going wrong

[Krydos]

Remote mysql is disabled by default for security reasons. Have you enabled remote mysql by clicking the button labeled "Remote Mysql" in cpanel and then entering your ip address or putting % to allow all ips to connect?