MYsql and APACHE

[Dr_s99]

i can't get them working together :P
i mean when i set it up...
i get an error that i can't connect to the database and that i'm !
well its here :
Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\Program Files\Apache Group\Apache2\htdocs\info.php on line 5
Could not connect to MySQL
i'm going nuts here :surrender i mean i keep getting mysql_connect(): Client does not support authentication protocol requested by server;
i don't know how to fix it... help!
PS: i'm a noob in setting up Mysql...
and i'm running it on windows 2003 :P

[rewt]

Need some more information to help you out.

What is on line 5 of info.php? What particular software (PHP related) are you using to connect to the database?

[rewt]

phpbb doesn't support the new versions of php/mysql

[Dr_s99]

the page is

<?php

// open the connection

$conn = mysql_connect('localhost', ****, "****");

// create database testdb

$create_success = mysql_create_db("testdb");
if($create_success)
echo("<b><font color=\"blue\">create database: success!</font></b><br>");

// pick the database to use

mysql_select_db("testdb",$conn);

// create the SQL statement

$sql = "CREATE TABLE testTable (id int not null primary key auto_increment,

testField varchar (75))";

// execute the SQL statement

$result = mysql_query($sql, $conn) or die(mysql_error());

// echo the result identifier

echo $result;

//close the connection to the db
mysql_close();

?>



but... here is the funny thing...!
this didn't work.. so i down graded PHP to 4
and installed XAMPP!
and all of sudden everything started to work :P

[rewt]

I don't understand why it won't let you connect to the database.

Maybe try creating the database with phpmyadmin (http://www.phpmyadmin.net/home_page/) or MySQL Front (http://www.mysqlfront.de/) instead.

[oldsk00l]

I use a mac, and I've been using cocoamysql. It's very similar to the MySql Front mentioned above. Never had problems.

[Dr_s99]

its odd!