Please help how can i connect MySQL from other PC?

Discussion in 'MySQL' started by myesmee, Mar 26, 2008.

  1. #1
    i write the code in VB to connect MySQL database. thia code able to connect at local PC, but when i install the program to other PC, it not able to connect MySQL Server.
    Please how what should i modify on the code or MySQL setting that to enable my to connect MySQL Server from other PC?

    Set conn = New ADODB.Connection
    conn.C _
    & "SERVER=localhost;" _
    & "DATABASE=myerp;" _
    & "UID=root;" _
    & "PWD=zoomic;" _
    & "OPTION=" & 1 + 2 + 8 + 32 + 2048 + 16384
    conn.CursorLocation = adUseClient
    conn.Open
     
    myesmee, Mar 26, 2008 IP
  2. wisdomtool

    wisdomtool Moderator Staff

    Messages:
    15,825
    Likes Received:
    1,367
    Best Answers:
    1
    Trophy Points:
    455
    #2
    Instead of

    SERVER=localhost

    Substitute with the IP and domain name of the My SQL server. Also ensure that that MySQL server had the port 3066 open.
     
    wisdomtool, Mar 26, 2008 IP
  3. myesmee

    myesmee Peon

    Messages:
    9
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    thanks for the help , how can i check is it MySQL Server port 3306 is open or not?
     
    myesmee, Mar 26, 2008 IP
  4. wisdomtool

    wisdomtool Moderator Staff

    Messages:
    15,825
    Likes Received:
    1,367
    Best Answers:
    1
    Trophy Points:
    455
    #4
    Me bad sorry 3306 :) Try to do a telnet to that port.

     
    wisdomtool, Mar 26, 2008 IP
  5. myesmee

    myesmee Peon

    Messages:
    9
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    sorry i not really know well on telnet
    can teach me how to do a telnet?
     
    myesmee, Mar 26, 2008 IP
  6. wisdomtool

    wisdomtool Moderator Staff

    Messages:
    15,825
    Likes Received:
    1,367
    Best Answers:
    1
    Trophy Points:
    455
    #6
    wisdomtool, Mar 26, 2008 IP
  7. myesmee

    myesmee Peon

    Messages:
    9
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #7
    thank for the help , is work.
     
    myesmee, Mar 26, 2008 IP