twilightnights Posted June 13, 2007 Share Posted June 13, 2007 I am using the exact same syntax as my 4.0 databases that work and everytime i get this error message "Could not connect: Client does not support authentication protocol requested by server; consider upgrading MySQL client" which I am assuming there is something wrong with the php code.. how do I fix it.. mysql_connect('x,'x','x') or die('Could not connect: ' . mysql_error()); mysql_select_db('x'); Quote Link to comment Share on other sites More sharing options...
twilightnights Posted June 13, 2007 Author Share Posted June 13, 2007 wow this is driving me nuts and I have to have this database done for a class presentation on friday Quote Link to comment Share on other sites More sharing options...
twilightnights Posted June 13, 2007 Author Share Posted June 13, 2007 Is there an alternate way to connect to the DB this makes no sense why this errors out on me Quote Link to comment Share on other sites More sharing options...
kenrbnsn Posted June 13, 2007 Share Posted June 13, 2007 There is an option to tell MySQL to use "old style passwords". Enable that and it will solve your problem. I will move this to the MySQL area where you might get more answers. Ken Quote Link to comment Share on other sites More sharing options...
twilightnights Posted June 14, 2007 Author Share Posted June 14, 2007 Thanks but I don't know how to access that.. I use go daddy hosting and they have the php and mysql set up for me, so I don't know how to edit the global settings or whatever. I settled with migrating the entire database to a 4.0 but I would really like to know how to fix it in phpadmin if it's possible Quote Link to comment Share on other sites More sharing options...
fenway Posted June 17, 2007 Share Posted June 17, 2007 You can just run OLD_PASSWORD() on the existing password in the users table, provided you have access to it. Quote Link to comment Share on other sites More sharing options...
whataf Posted June 29, 2007 Share Posted June 29, 2007 I am having this exact same problem (I use godaddy as well) and the error for the connection comes out as: "Could not connect: Client does not support authentication protocol requested by server; consider upgrading MySQL client" You can just run OLD_PASSWORD() on the existing password in the users table, provided you have access to it. I am new to using both PHP and MySQL (a couple weeks), can someone please explain how I can do this in more detail? or even better if twilightnights found a solution, could you tell me how you solved it? thanks Quote Link to comment Share on other sites More sharing options...
fenway Posted June 29, 2007 Share Posted June 29, 2007 Read here: http://www.mysql.org/doc/refman/4.1/en/old-client.html Basically, PHP 4 doesn't support mysql 4.1... so either you need to fix the db server, or upgrade to php 5's mysqli libraries. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.