Remote connection to MySQL with VB6-VBForums
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
    Super Moderator Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,335

    Re: Remote connection to MySQL with VB6

    Maybe this helps?
    Please use [Code]your code goes in here[/Code] tags when posting code.
    When you have received an answer to your question, please mark it as resolved using the Thread Tools menu.
    Before posting your question, did you look here?
    Got a question on Linux? Visit our Linux sister site.
    I dont answer coding questions via PM or EMail. Please post a thread in the appropriate forum section.

    Creating A Wizard In VB.NET
    Paging A Recordset
    What is wrong with using On Error Resume Next
    Good Article: Language Enhancements In Visual Basic 2010
    Upgrading VB6 Code To VB.NET
    Microsoft MVP 2005/2006/2007/2008/2009/2010/2011/2012/Defrocked

  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
  •  



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.