Jump to content


remote mysql

  • Please log in to reply
1 reply to this topic

#1 hinditut



  • 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






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


    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