Error In Connecting From VB To MySQL { Redhat }

Hi there,

I am actually trying to use a VB program (window) to connect to a MySQL database (linux).
I had granted the permission for the mysql to allow connection from my PC but I still kept getting
the same error message below.

Tools that I had Used :
-----------------------------
1. Visual Basic 6
2. MySQL 4.0.13
3. MyODBC-3.51.06
4. Linux Red Hat Advanced Server
5. Window XP

Steps that I had taken :
------------------------------
1. Run the following command
GRANT ALL ON *.* TO gilabean@192.168.0.100 IDENTIFIED BY 'gilabean'
2. Try to connect by running the VB program.

The funny thing is that I tried it on another server and it works perfectly fine but when I tried it
on this server, it just couldn't connect to it and kept getting an error for that.

I would be grateful if anyone can point to me where's my fault because I kept on getting the same error
message when I tried to connect to the MySQL server on the particular IP.

***********************************************************************
* Run Time error '-2147467259 (80004005)' *
* [MYSQL][ODBC 3.51 Driver]Can't connect to MySQL server on '192.168.0.100' (10054) *
***********************************************************************


Cheers,
½nut

Question 1) You were able to connect to the mysql server on another machine, but not the one that you are currently trying from. Did you use the same program to try and connect with?
Question 2) Can you see the server? i.e. can you ping it?

Hi onslaught,

answer 1. Yep, I'm using the same program to connect. I just change the ip of the server. That's it.

answer 2. Yeah, I can see the server and I can even ssh into it.

Till now I still haven't get the answer why I can't connect to the live server. I don't even have any idea on what's wrong too~ LoL.


cheers,
½nut

What is being logged in the MySQL error log? Are you granting wildcard access or are you host masking?