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?