p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   PHP Databases (http://p2p.wrox.com/forumdisplay.php?f=97)
-   -   Need Help Connecting to mySQL Database! (http://p2p.wrox.com/showthread.php?t=20885)

jehchoi1 November 5th, 2004 05:53 PM

Need Help Connecting to mySQL Database!
 
Can someone tell me why I am getting this message:

"Client does not support authentication protocol requested by server; consider upgrading MySQL client"

System Setup:
Running Apache 2 with PHP 4.3.9 on Windows XP
and mySQL 4.1.7

PHP Code Used:
mysql_connect("localhost", "userid", "password") or
die(mysql_error());

Any help will be appreciated
Thanks

anshul November 6th, 2004 08:02 AM

u may try Win2000 Pro/Server or Win2003 :)

richard.york November 6th, 2004 09:47 AM

Although I haven't heard of the error you're talking about, using a Microsoft server will not overcome it.

Check out the docs and mailing lists at http://www.mysql.com. I'm sure someone there has a clue of what's happening.

Regards,
Rich

--
[http://www.smilingsouls.net]
[http://pear.php.net/Mail_IMAP] A PHP/C-Client/PEAR solution for webmail

ajutla February 2nd, 2005 04:13 PM

try to set register_globals to On and try it.


p2ptolu February 26th, 2005 11:08 AM

mysql on my system works alone but can not connect to php, i use php4 and mysql 4.1 on apache 1.33 all om win xp pro,please help me too.


Alej April 16th, 2005 03:34 PM

Thanks, 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! 'yourpassword'
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..

Mantis April 21st, 2005 09:28 AM

Ho yes, I tried to do that I remember; Then I decided that a better use of my time was to use an internet host.




All times are GMT -4. The time now is 03:24 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.