Php5 And Mysql...

antifreezeantifreeze The guy with the goods! Join Date: 2003-05-12 Member: 16232Members, Constellation
edited October 2004 in Off-Topic
<div class="IPBDescription">Makes my head sting....</div> For the last few days i have been trying to set up an apache PHP5 MySql server. The apache bit is fine and so is the PHP bit, it's just the damned my SQL bit. I got all the DLL's installed (before when i did it wrong the apache server wouldn't start but now it does so i guess it's right).

Apache = 2.0
PHP = 5
MySQL = 4.1.7

I downloaded some code from the net to test that it's working and it all i get is this messege.
<!--QuoteBegin--></div><table border='0' align='center' width='95%' cellpadding='3' cellspacing='1'><tr><td><b>QUOTE</b> </td></tr><tr><td id='QUOTE'><!--QuoteEBegin-->
Warning: mysql_connect() [function.mysql-connect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client in Z:\wwwroot\TestScripts\test.php on line 19
Could not connect: Client does not support authentication protocol requested by server; consider upgrading MySQL client
<!--QuoteEnd--></td></tr></table><div class='postcolor'><!--QuoteEEnd-->
I have no idea why it's doing this but when i open the MySQL admin thing the aborted connects rises everytime i run the script.

Any idea why it's happening and how to fix it?

EDIT:
<!--QuoteBegin-The Test Script+--></div><table border='0' align='center' width='95%' cellpadding='3' cellspacing='1'><tr><td><b>QUOTE</b> (The Test Script)</td></tr><tr><td id='QUOTE'><!--QuoteEBegin-->
<HTML>
<HEAD></HEAD>
<BODY>

<?php

define("SQL_HOST", "localhost");  // Name or IP of MySQL server
define("SQL_USER", "root");  // MySQL user name
define("SQL_PWD", "SNIP");  // MySQL password
define("SQL_DB", "phphits");  // Name of database
define("SQL_TABLE", "log");  // Name of table

define("SQL_SHOW_ERRORS", "1");  // Should the script produce MySQL error messages or not

/////////////// Connect to MySQL server ///////////////

//$sql_id = @mysql_connect(SQL_HOST, SQL_USER, SQL_PWD)

$link = mysql_connect(SQL_HOST, SQL_USER, SQL_PWD)
  or die('Could not connect: ' . mysql_error());
echo 'Connected successfully';

?>

</BODY>
</HTML>
<!--QuoteEnd--></td></tr></table><div class='postcolor'><!--QuoteEEnd-->

Comments

  • jumpingjodajumpingjoda Join Date: 2003-12-14 Member: 24367Members, Constellation, Reinforced - Shadow
    There is a easy solution to run a PHP/MySQL server!
    <a href='http://www.apachefriends.org/en/' target='_blank'>Apachefriends</a> is an organisation which provides a package that runs both, easy as pai.
    The thing you need is <a href='http://www.apachefriends.org/en/xampp.html' target='_blank'>XAMPP</a> (available for linux and windows).

    There are also plugins so you can enable Perl support and many other things.
    Have fun.
  • DOOManiacDOOManiac Worst. Critic. Ever. Join Date: 2002-04-17 Member: 462Members, NS1 Playtester
    I think he wanted a fix, not an ad. :P

    antifreeze: I haven't messed w/ apache, mysql, and php on windows, but it sounds like you have your mysql server set up to not allow remote connections. Or is this all on one box?

    Can you log into the mysql server w/ that username and password directly (as in, on that same box)?
  • antifreezeantifreeze The guy with the goods&#33; Join Date: 2003-05-12 Member: 16232Members, Constellation
    I eventually decided to download XAMPP and then spend 2 hours making it work like it's not XAMPP and run in different directories with different passwords. Got it sorted which is good and took less time than setting up apache etc from scratch. It's good enough for what i need it for.
Sign In or Register to comment.