Odbc Connection

[kinggrapes]

At the end of Feb I had trouble connecting by my database via odbc. The porblem was solved - I suspect rhough some server adjustment by Rick Veazey. See this thread

http://www.totalchoicehosting.com/forums/i...c=26375&hl=odbc

 

However, I am having the same problem on a second domain today

http://porterordhids.co.nz

 

My site works and connects fine, so database, users etc are all established.

I've added my IP address to the "access Hosts" list.

 

Any ideas?

[TCH-Bruce]

If Rick fixed it then it could have been a server related issue. You should open a ticket with the help desk and have them check for you. The mods don't have access to the servers and the techs don't frequent the forums regularly.

[mredmond]

Hey guys, I need some help. I do not have a static IP address. I went to the whatismyip.com and put the reported Ip address in the "access Hosts" on mySQLAdmin. I am still getting the following error:

 

[MySQL][ODBC 3.51 Driver]Access denied for user 'kwsuki'@'ip24-254-38-172.br.br.cox.net' (using password: YES)

 

I feel confident that the User and Password are entered correctly. I'd appreciate any advise.

[TCH-Tim]

Looks like you don't have the correct username. Your database username is in the form cpanelUsername_databaseUsername.

[mredmond]

Looks like you don't have the correct username. Your database username is in the form cpanelUsername_databaseUsername.

 

Please elaborate. I am using my MySQL databases for a Movable Type site and I am having no problem with that. I am using the same User name and Password that I have in the mt_config.cgi script.

Edited May 30, 2006 by mredmond

[TCH-Thomas]

Welcome to the forum, mredmond.

[TCH-Bruce]

Welcome to the forum, mredmond

 

Your user name to access the database would be you-cpanelID_user-name

[mredmond]

Your user name to access the database would be you-cpanelID_user-name

 

The only name associated with my database IS my cPanel name. I have not created any additional users and Movable Type is working fine. Wouldn't I have a problem with MT accessing the databases if I did not have the necessary names set up?

[TCH-Bruce]

If you have not created a user and added it to the database you will not be able to access it.

[mredmond]

If you have not created a user and added it to the database you will not be able to access it.

Please educate me if you can. I am using Movable Type, every day, as I learn how to maintain that site. Am I NOT accessing the MySQL databases? When I go into phpMyAdmin I see all the work that I have done. The records are there! The only user shown has the same name as the cPanel User ID. I do not remember creating that user, but perhaps I did. That is the name I am using.

 

Example:

 

cPanel name = kwsuki

MySQL user = kwsuki

Password = password (not really)

 

When createing the DSN for ODBC connectivity, do I have to say

 

user name = kwsuki_kwsuki

 

I have actually already tried that and I get the same error.

 

I tried submitting a Help Desk ticket. They responded to try to add the % wildcard to my access host since I don't have a dedicated IP and then fussed at me for submitting a non-server related issue. Told me to try the forums, which I have been trying to do? I'll have to wait until I get home to try the wildcard suggestion. Until then, I'll keep groping. If anyone has any more ideas, let me know.

[TCH-Tim]

It looks like you created a database user without actually providing a username. That gives you a full database username of "kwsuki_" without the quotes. There is nothing after the underscore because nothing was entered in the username box. Try that and let us know how it goes.

[mredmond]

I tried every combination of kwsuki with the '_', without it, etc. I finally gave in and created another user and added him to the database and it worked. Go figure!

 

Thanks for the help guys!

[TCH-Bruce]

I'm surprised it's working for you with MT.

 

In the future the proper way is to create a database, create a user and add the user to the database.