Results 1 to 5 of 5

Thread: how to connect to mysql5.0 from php4? help me plzz

  1. #1
    Join Date
    Nov 2006
    Location
    Nilai
    Posts
    4
    Rep Power
    0

    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

  2. #2
    Join Date
    Jan 2007
    Location
    Shah Alam
    Posts
    9
    Rep Power
    0
    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

  3. #3
    Join Date
    Nov 2006
    Location
    Nilai
    Posts
    4
    Rep Power
    0
    may i know how to check... and if it is using different encryption, how to solve it??? anybody plzzz... thanks

  4. #4
    Join Date
    Jan 2007
    Location
    Shah Alam
    Posts
    9
    Rep Power
    0
    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.

  5. #5
    Join Date
    Nov 2006
    Location
    Nilai
    Posts
    4
    Rep Power
    0

    thanksss

    thx so much banjir.... it works...thx

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Connect To Database
    By JDream in forum Website Programming
    Replies: 3
    Last Post: 04-06-2008, 07:08 PM
  2. [Singapore] Windows (HELM) - ASP.Net, SQL 2000, PHP4 - Double Disk Space & Data
    By xhosts in forum Other Webmaster-related Services and Promotion
    Replies: 0
    Last Post: 07-10-2005, 06:33 PM
  3. plzz..help me
    By dyda in forum Website Programming
    Replies: 6
    Last Post: 21-03-2004, 09:43 PM
  4. Review our site plzz...
    By Sic in forum Websites Review and Suggestion
    Replies: 6
    Last Post: 13-01-2004, 05:53 AM
  5. invision board + mySQL + php4
    By chrischua in forum Website Programming
    Replies: 7
    Last Post: 08-08-2003, 12:37 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Search Engine Optimization by vBSEO 3.5.0 RC1 PL1

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 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112