Results 1 to 4 of 4

Thread: Remote connection to MySQL with VB6

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Jul 2006
    Location
    Philippines
    Posts
    78

    Remote connection to MySQL with VB6

    I created a program in vb6 that uses MySQL as back-end. Everything works fine when I'm using it locally (using localhost for Server). But when I tried to run my vb6 program from other computer and connects to the MySQL server from different computer (I've changed "localhost" to the IP address of the computer where the MySQL database is installed) it outputs an error message:

    Run-time error '-214767259 (80004005)':
    [MySQL] [ODBC 3.51 Driver] Host "Computer01" is not allowed to connect to this MySQL server

    I've read some articles and discussions about this problem and I've found out that MySQL, by default, does not allow remote connection. To enable it, MySQL must be configured or use SSH.

    My problem now is I don't know how to configure MySQL or even use SSH. Can someone tell me how to configure it?
    To become a PROFESSIONAL,
    Start from SCRATCH...

  2. #2
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: Remote connection to MySQL with VB6

    Maybe this helps?

  3. #3

    Thread Starter
    Lively Member
    Join Date
    Jul 2006
    Location
    Philippines
    Posts
    78

    Re: Remote connection to MySQL with VB6

    What do you usually use when creating a vb6 programs that uses MySQL as back-end?
    To become a PROFESSIONAL,
    Start from SCRATCH...

  4. #4

    Thread Starter
    Lively Member
    Join Date
    Jul 2006
    Location
    Philippines
    Posts
    78

    Re: Remote connection to MySQL with VB6

    My problem is now solved!

    I downloaded "myphpadmin" and place it on my apache web server. I run it in a web browser then edited my MySQL database. I changed its priviledges and assign a new username and password. I can now connect my vb6 program remotely to the MySQL server.
    To become a PROFESSIONAL,
    Start from SCRATCH...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width