how to allow access to mySQL from another computer on local network?

[Victor Lopez]

I installed MySQL 5.1 on a server with Windows 2003. I installed the
MySQL ODBC 5.1 connector installed on the computer and configured. And
also on the remote PC.
Service is running properly and am unable to connect to the database.

From another machine (192.168.1.40), which has Windows XP. With the
MySQL ODBC connector installed, as I said before, I try to connect to
the server and it is not possible but gives no error message, waits.

On the server I created a generic user ''@'%'( norberto using the
GRANT) with password; is the same place it in the VB6 application to
connect and use is the same as the ODBC connector on the client
computer .

The Windows XP, the firewall settings I have also open TCP port 3306,
and then the firewall disabled, but the problem remains the same.

I do not know what else to do to connect?

Thank you very much

[Randell_D]

Download and install the MySQL GUI (its now archived, superceeded with
a new tool that I am not yet familiar with) on the MySQL pages

http://dev.mysql.com/downloads/gui-tools/5.0.html

Install the tool on your client and see if that will allow you to
connect to the server - if it does, then you know the problem is your
syntax. I've not used ODBC connector and thus don't know if you've
provided sufficient information for someone to be able to assist you
or not... I'm guessing though that you got your GRANT defined
wrongly... You could check your MySQL server log file using notepad
and see if your connections are being denied (in which case your
attempts to connect with ODBC are at least confirmed) or not.