Cant Connect

hansalas · April 13th, 2005, 01:03 AM

Code:

mysql_connect("localhost","user","pass") or  
die("Could not connect!!^_^" . mysql_error());

----------------------------------------------------------------------

the error msg i received is this.....
-----------------------------------------------------------------------------
Client does not support authentication protocol requested by server; consider upgrading MySQL client
-----------------------------------------------------------------------------

Thanks guys.

My configuration is

IIS
Win 2K
MySQL 4.1.7
PHP Version 4.3.11

Moharo · April 13th, 2005, 09:22 AM

try doing just this:

mysql_connect("localhost");

do not specify username and password....

www.campusgrind.com -college portal

Alej · April 16th, 2005, 03:25 PM

I did set up my password by using :
"set password for root@loacalhost=password('your_password');
log out "\q", and then log back with:
mysql -u root -p,
prompts for password! 'your_password'
and then I get the wellcome monitor screen.
then I make sure I place the same password in my PHP script, at hte
mysql_connect () function.
and I now get : Can't create database 'wiley'. Database exists.
My hole next week will be dvoted to this message NOW..