Jump to content


Photo

how to connect php with mysql database


  • Please log in to reply
5 replies to this topic

#1 raj_verma

raj_verma
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 01 May 2006 - 05:52 AM

Hello Everyone,

When i m connecting mysql database to php
there is showing an error.
Please help me guys to sorting it out.
I m very new to this language.

The error is as follow :-Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\raj\database.php on line 13

[color=#FF0000]

Please reply me as soon as possible

Thanks

#2 wildteen88

wildteen88
  • Staff Alumni
  • Advanced Member
  • 10,482 posts
  • LocationUK, Bournemouth

Posted 01 May 2006 - 10:17 AM

Could you provide details on the versions of PHP and MySQL.

Also I believe you have to configure MySQL to use the old passwords directive to sort this issue out.

#3 raj_verma

raj_verma
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 01 May 2006 - 10:52 AM

[!--quoteo(post=370250:date=May 1 2006, 05:17 AM:name=wildteen88)--][div class=\'quotetop\']QUOTE(wildteen88 @ May 1 2006, 05:17 AM) View Post[/div][div class=\'quotemain\'][!--quotec--]
Could you provide details on the versions of PHP and MySQL.

Also I believe you have to configure MySQL to use the old passwords directive to sort this issue out.
[/quote]


I m using php 4.2 and mysql 4.1
You are saying that I have to configure MySQL please tell me how i configure MySQL
And also sort my problem how i connect MySQL to PHP.

I will be thankful to you to sorting out this problem

Please reply as soon as possible

#4 craygo

craygo
  • Staff Alumni
  • Advanced Member
  • 1,973 posts
  • LocationRhode Island

Posted 01 May 2006 - 01:12 PM

The fix can be found here. You have to do this from the mysql prompt.

[a href=\"http://www.digitalpeer.com/id/mysql\" target=\"_blank\"]http://www.digitalpeer.com/id/mysql[/a]

or here

[a href=\"http://dev.mysql.com/doc/refman/5.0/en/old-client.html\" target=\"_blank\"]http://dev.mysql.com/doc/refman/5.0/en/old-client.html[/a]

This has to be done from php version 4.x.x to current

Ray

#5 irene169

irene169
  • Members
  • PipPip
  • Member
  • 10 posts

Posted 01 May 2006 - 05:09 PM

EDITED BY WILDTEEN88: PLEASE POST YOUR PROBLEM IN A NEW THREAD RATHER THAN IN A CURRENT THREAD WHICH YOUR PROBLEM DOESN'T RELATE TO THANK YOU

#6 raj_verma

raj_verma
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 02 May 2006 - 05:57 AM

Thanks a lot.
This really works

Thanks once again.





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users