-
Dec 28th, 2007, 08:49 AM
#1
Thread Starter
Lively Member
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...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|