Jump to content


Photo

MyODBC connection problem


  • Please log in to reply
1 reply to this topic

#1 novice

novice
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 11 April 2003 - 10:52 PM

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.

#2 shivabharat

shivabharat
  • Members
  • PipPipPip
  • Advanced Member
  • 371 posts
  • LocationChennai, India

Posted 11 April 2003 - 11:39 PM

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!!
Knowledge --- Reading Enriches Mind But Sharing Enhances It.[br][br]Note: Before you request help enusre that you have had a look at the tutorials @phpfreaks




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users