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.