MyODBC connection problem

[novice]

I have a LAN consisting of 2 machines. One of them has Redhat linux 7.2 as its OS with MySQL running on it. This machine also has an Apache server. I have hosted a php web site on this machine and everything works fine when this web site accesses its MySQL database. This machine also has another MySQL db called \"temp\" which is essentially a db for test purposes.

 

The second machine has WIN2K Professional as its OS. The name of this machine is WIN2K. I downloaded & installed MyODBC on this m/c. The information I have entered in the DSN Configuration dialog box is as follows:

 

Data Source Name: myodbc3-test

Description: mySQL ODBC 3.51 TEST DSN

 

Host Server Name: 192.168.50.1 (internal IP address of the m/c on which I have the \"temp\" db

Database Name: temp

User: novice

Password:

Port: 3306

SQL Command:

 

Problem: when I click on the \"Test Data Source\" button I get the following error message:

 

[MySQL][ODBC 3.51 driver]Access denied for user: \'novice@WIN2K\' to database \'temp\'

 

On the m/c that has the MySQL server, I looged in and using the mysql client, I typed in the following SQL statement:

 

grant all privileges on db.temp to novice@WIN2K;

 

Could anyone possibly let me know what I might be doing wrong.

 

Thanks in advance for your time.

[shivabharat]

Give full rights to the database which u are trying to connect.

 

see the user u specified has the necessary right

 

I am sure it will work!!