Odbc Connectivity

[mredmond]

I have recently set up phpNuke on my site using the Fantastico script assistant. It creates a MySQL database and sets up a config.php file which has the database name, userid and password.

 

Using cPanel, I have created another MySQL database and I am trying to set up an ODBC connetion to it. I am using the same userid and password as in the config file, changing only the database name, but using the same cPanel_database convention as with the phpNuke database. But so far, no luck. I get a "cannot connect ..." error.

 

Any suggestions?

[nortk]

For each database you create, you must also add a user to that database. You could add the same user as the one on your phpnuke db, or you could create a new user and add it to the new database.

 

See if that helps.

[TCH-Andy]

You will also need to enable remote connections to your databases (you do that in the mySQL section of cpanel).

[mredmond]

You will also need to enable remote connections to your databases (you do that in the mySQL section of cpanel).

 

That was it. You guys are terrific. Thanks.

[mredmond]

That was it. You guys are terrific. Thanks.

 

Let's take this one more step.

 

Now that I can connect, the database field in the Windows ODBC setup application is supposed to populate with the various databases that I have access rights to. But none are showing up. I DO have rights to the tables, bu tnone are showing up.

 

Please advise. Thanks.

[TCH-Andy]

from memory, you need to tell it the name of the database (it doesn't just scan and tell you a list of all in some software). Once you have told it the name of the database - it should list the tables fine.

 

It's not my area of expertise - someone else might be along who can help. If not, PM me, and if you can set up a user for me - I'll test.

[mredmond]

Well guys and gals, I've been doing some hunting. I managed to find the following link:

 

http://bugs.mysql.com/bug.php?id=7987

 

In it, John Collins had the answer. He writes that MSAccess looks for user Admin when attempting to connect to an MySQL database using ODBC. I created a user ADMIN and Voila!

 

So regardless of the users you have set up and regardless of the success of the TEST, you won't connect until you set up a user ADMIN and assign it to your databases. I am not a system guru; I don't know the inner workings and I don't really want to - but this worked.

 

Thanks, John Collins!

[TCH-Don]

Thanks for the update and solution

[TCH-Andy]

Thanks for the update

[TCH-Bruce]

Leave it to Microsoft to assume (force) Admin for the user name. Since that's the only way it will work doesn't that make it a security risk? Anyone trying to access the db will already know the user name and only have to guess the password.