Jump to content


Photo

remote mysql


  • Please log in to reply
1 reply to this topic

#1 hinditut

hinditut

    Newbie

  • Members
  • 1 posts

Posted 21 November 2020 - 05:00 PM

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



#2 Krydos

Krydos

    Rank X Member

  • Root Admin
  • 21,470 posts
  • Gender:Male

Posted 21 November 2020 - 08:55 PM

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?






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users