MyODBC Connection Problem

[BOBRIVER]

I was trying to establish a DSN using myodbc 5.1 to a live website's mysql database.

I could finally get the DSN connection to successfully connect to the remote MySQL server using the hostname, username and password only . It succeeded, but when I use the database name in the DSN configuration it fails to connect the username to the database. although the entries are all correct and I tried to create different users for that database.

The connection succeeded with all the users, it fails only when you input the database name even though they are all users of that specific database.

[Atli]

Hey.

Are you sure you set the correct value for the host when you granted the users access to the database?

Try checking the mysql.db table and see if it contains the correct values.

SELECT `Host`, `Db`, `User` FROM mysql.db WHERE `User` = 'Atli';

[BOBRIVER]

Dear Atli

I checked that , everything was okay>
where can I find the mysql.db table?

Bob

[Atli]

where can I find the mysql.db table?

It's the "db" table of the "mysql" database. You will need root-like privileges to access it though. Just execute the query I posted and you will see whether you can access it or not.

[BOBRIVER]

I tried to run the query on the sql command window phpmyadmin-mysql
it returns (no database selected)
in my databases section I can't see other than the websites databases
I downloaded the latest version of MyODBC 3.xxx and I still have the same problem. it connects without a database name only