Go Back   Webmaster Malaysia Forum » Website Design & Development » Website Programming

Reply
 
LinkBack Thread Tools Search this Thread Rate Thread Display Modes
  #1 (permalink)  
Old 15-01-2007, 09:55 AM
New kid on the block
 
Join Date: Nov 2006
Location: Nilai
Posts: 4
Rep Power: 0
SolidLucky is on a distinguished road
how to connect to mysql5.0 from php4? help me plzz

hey guys... i need ur help... i have problem on how to connect to mysql 5 from php 4. Normally i used mysql 4 and there is no problem with it.. when i change to mysql 5 there is warning said that

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\Program Files\Apache Group\Apache2\htdocs\test\test.php on line 12
Failed connect to db


anyone know how to solve it???? plssssssss...thx
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 16-01-2007, 12:21 AM
New kid on the block
 
Join Date: Jan 2007
Location: Shah Alam
Posts: 9
Rep Power: 0
banjir is on a distinguished road
Quote:
Originally Posted by SolidLucky View Post
Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\Program Files\Apache Group\Apache2\htdocs\test\test.php on line 12
pls check if mysql_connect() is using the same encryption that mysql5 use
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 16-01-2007, 10:19 AM
New kid on the block
 
Join Date: Nov 2006
Location: Nilai
Posts: 4
Rep Power: 0
SolidLucky is on a distinguished road
may i know how to check... and if it is using different encryption, how to solve it??? anybody plzzz... thanks
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 17-01-2007, 03:52 PM
New kid on the block
 
Join Date: Jan 2007
Location: Shah Alam
Posts: 9
Rep Power: 0
banjir is on a distinguished road
The bundled version of libmysql library with PHP4 does not handle authentication of new MySql5, so you can not connect to the database. Try using PHP5. Or find the libmysql version that works with MySql5.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old 18-01-2007, 09:30 AM
New kid on the block
 
Join Date: Nov 2006
Location: Nilai
Posts: 4
Rep Power: 0
SolidLucky is on a distinguished road
thanksss

thx so much banjir.... it works...thx
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

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
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
plzz..help me dyda Website Programming 6 21-03-2004 09:43 PM
can't connect to mysql server on localhost nurulmajdi Website Programming 6 16-02-2004 03:57 PM
Review our site plzz... Sic Websites Review and Suggestion 6 13-01-2004 05:53 AM
invision board + mySQL + php4 chrischua Website Programming 7 08-08-2003 12:37 AM
Linux mandrake can connect to streamyx?? tkh135 Mamak Stall 13 27-07-2003 12:34 PM



All times are GMT +8. The time now is 05:45 PM. Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
LinkBacks Enabled by vBSEO 3.1.0 vBulletin skin by ForumMonkeys.com.


WebmasterMalaysia.com is Proudly Hosted by Exabytes Semi Dedicated Server.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60