logo-dw

Go Back   Dreamweaver Club Forums > Dreamweaver forums > Web Hosting and FTP
Register FAQ Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Display Modes
Old 07-02-2008, 09:56 PM   #1
swissbeets
 
Join Date: Jun 2008
Posts: 57
Default website hosted but not connecting to mysql

i 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?
swissbeets is offline   Reply With Quote
Old 07-02-2008, 09:59 PM   #2
swissbeets
 
Join Date: Jun 2008
Posts: 57
Default

also the database is working fine on the website i have checked that a few times
swissbeets is offline   Reply With Quote
Old 07-03-2008, 05:47 AM   #3
davidj
davidj's Avatar
 
Join Date: Sep 2005
Location: The Toon (newcastle upon Tyne)
Posts: 8,256
Default

check the versions on your live and local environments

see if they are different
__________________
Would you like to learn PHP from me? Check out -> www.codezenith.co.uk
davidj is offline   Reply With Quote
Old 07-03-2008, 05:57 AM   #4
davidj
davidj's Avatar
 
Join Date: Sep 2005
Location: The Toon (newcastle upon Tyne)
Posts: 8,256
Default

also found this...

http://forums.oscommerce.com/index.p...post&p=1037894

and this

http://dev.mysql.com/doc/refman/5.0/en/old-client.html
__________________
Would you like to learn PHP from me? Check out -> www.codezenith.co.uk
davidj is offline   Reply With Quote
Old 07-03-2008, 03:15 PM   #5
swissbeets
 
Join Date: Jun 2008
Posts: 57
Default tried....

ok i used

http://dev.mysql.com/doc/refman/5.0/en/old-client.html

and did the
mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd')
-> WHERE Host = 'some_host' AND User = 'some_user';
mysql> FLUSH PRIVILEGES;

after this i updated my database on godaddy didnt do anything...I am not using an old version of mysql and when i clicked what version i was using in godaddy, i clicked 5.0( when checked in the advanced settings on godaddy there version 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
.

could this difference be a problem?
my current version is 5.051b
could any of this be a problem with my config.inc.php file not being shared right or not having the correct values?

Last edited by swissbeets; 07-03-2008 at 03:27 PM..
swissbeets is offline   Reply With Quote
Old 07-03-2008, 10:16 PM   #6
swissbeets
 
Join Date: Jun 2008
Posts: 57
Default

i think i got it i knew it was just a dumb mistake i thought i had everything right but i couldnt find it for the life of me...... thank you very much for your help
swissbeets is offline   Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 08:46 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Copyright 2006 DreamweaverClub.com