-
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...
-
Dec 28th, 2007, 09:00 AM
#2
Re: Remote connection to MySQL with VB6
-
Dec 28th, 2007, 09:37 AM
#3
Thread Starter
Lively Member
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...
-
Dec 29th, 2007, 04:27 AM
#4
Thread Starter
Lively Member
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|