website hosted but not connecting to mysql

JavaScript and client side scripting.

Moderator: General Moderators

Post Reply
swissbeets
Forum Newbie
Posts: 20
Joined: Thu Jun 26, 2008 7:56 pm

website hosted but not connecting to mysql

Post by swissbeets »

am getting this error, everything is hosted on godaddy.com but for some reason nothing is coming up

Database connection failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client

while using all of the same information and connecting to the localhost it runs perfectly any suggestions?
User avatar
califdon
Jack of Zircons
Posts: 4484
Joined: Thu Nov 09, 2006 8:30 pm
Location: California, USA

Re: website hosted but not connecting to mysql

Post by califdon »

swissbeets wrote:am getting this error, everything is hosted on godaddy.com but for some reason nothing is coming up

Database connection failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client

while using all of the same information and connecting to the localhost it runs perfectly any suggestions?
Well, yes, you're connecting to a different server at a different host and maybe different database name and password.

If you're not sure about your godaddy.com database connection information, it's available in your My Account section of your online control panel (I'll admit, it's not really easy to find, their control panels suck!).
swissbeets
Forum Newbie
Posts: 20
Joined: Thu Jun 26, 2008 7:56 pm

Re: website hosted but not connecting to mysql

Post by swissbeets »

ok i got it all correct i have been on the phone with godaddy all day but after talking to the godaddy representative he thought the problem may be with wamp i am not sure what has to be changed for wamp to work but i dont know what things have to be changed. the site worked fine on my localhost and i changed all the connection information that i know of also i know for a fact the database is working i feel like it is something small but i just dont know what to check any help would be greatly appreciated
User avatar
califdon
Jack of Zircons
Posts: 4484
Joined: Thu Nov 09, 2006 8:30 pm
Location: California, USA

Re: website hosted but not connecting to mysql

Post by califdon »

swissbeets wrote:ok i got it all correct i have been on the phone with godaddy all day but after talking to the godaddy representative he thought the problem may be with wamp i am not sure what has to be changed for wamp to work but i dont know what things have to be changed. the site worked fine on my localhost and i changed all the connection information that i know of also i know for a fact the database is working i feel like it is something small but i just dont know what to check any help would be greatly appreciated
I don't understand. Is your godaddy account a Microsoft server? I don't think they use wamp, do they? Confirm what kind of a server your godaddy account is on, and show us your MySQL connection code except don't use your actual server number, user, or password.
swissbeets
Forum Newbie
Posts: 20
Joined: Thu Jun 26, 2008 7:56 pm

Re: website hosted but not connecting to mysql

Post by swissbeets »

define("DB_SERVER", "******.secureserver.net");
define("DB_USER", "chris");
define("DB_PASS", "password");
define("DB_NAME", "website");


many forums are saying that i need to change my password hashing to fit an older mysql but the version of mysql i am using is 5.051b
while the version godaddy uses is
<li id="li_server_info">Server version: 5.0.45-log<li id="li_mysql_client_version">MySQL client version: 5.0.27<li id="li_mysql_proto">Protocol version: 10

i did the password changing and reuploaded my database, but still nothing when these databases are updated on my local computer is there a step to make sure they are updated online also, because when i looked at the sql it had nothing to do with these passwords


also i was using WAMP on my local machine which worked perfectly for me. woudl anything need changed because of this?
User avatar
califdon
Jack of Zircons
Posts: 4484
Joined: Thu Nov 09, 2006 8:30 pm
Location: California, USA

Re: website hosted but not connecting to mysql

Post by califdon »

OK, your connection info looks valid, assuming that they are actually the correct values that match your godaddy account. Have you tried opening your database through godaddy's phpmyadmin, using those same values? (Go to My Account, My Hosting Accounts, Manage Account, Databases) If you can open your database there, then you know that those are the correct values for username and password and you know the database exists. That pretty much seems to narrow it down to authentication, alright.

I don't see how it matters WHAT you're using on your own local computer, as long as your syntax is correct for the version of MySQL and PHP you're connecting to. Maybe somebody with more systems knowledge can shed more light on this, but I've never had the least problems with my 9 databases (dozens of tables) at godaddy, and I use wamp here. Indeed, most of my databases are old MySQL 4.0, except for one 5.0. I think it might be worth another call to godaddy. I've found their techies to be very good, but asking the same question to another person just might clear this up very quickly. They are anxious to have you use their services successfully, to keep you as a customer.
Post Reply