Hello everyone,
I have a little bit problem here.I have installed PHP version 4.4.1 and it's working well. I want to connect PHP with MySQl . I have also installed MySQL and it installed successfully.
Inorder to configure PHP to work with Mysql, I did the following changes in the c:\ windows\php.ini .
Uncomment (Removing semicolon) the line that follows extension=php_mysql.dll and extension=php_mbstring.dll .
The next step, i typed the following code in the notepad and saved it htdocs file and named as dbtest.php
<?php
$db_server = "localhost";
$db_user = "root";
$db_pwd = ""; //Enter your root password here.
$db_db = "mysql";
if (!$cnn = mysql_connect($db_server, $db_user, $db_pwd)) {
echo mysql_error();
exit();
}
if (!mysql_select_db($db_db, $cnn)) {
echo mysql_error();
exit();
}
$sql = "select * from help_category";
if (!$res = mysql_query($sql, $cnn)) {
echo mysql_error();
exit();
}
while ($row = mysql_fetch_array($res, MYSQL_ASSOC)) {
$data[] = $row;
}
?>
<html>
<head>
<title>Apache/PHP/MySql Test</title>
</head>
<body>
<h1>Help Categories</h1>
<?
echo "<style>table.dump { font-family:Arial; font-size:8pt; }</style>";
echo "<table class=\"dump\" border=\"1\" cellpadding=\"1\" cellspacing=\"0\">\n";
echo "<tr>";
echo "<th>#</th>";
foreach($data[0] as $key=>$val) {
echo "<th><b>";
echo $key;
echo "</b></th>";
}
echo "</tr>\n";
$row_cnt = 0;
foreach($data as $row) {
$row_cnt++;
echo "<tr align='center'>";
echo "<td>".$row_cnt."</td>";
foreach($row as $val) {
echo "<td>";
echo $val;
echo "</td>";
}
echo"</tr>\n";
}
echo "</table>\n";
?>
</body>
</html>
then i run the dbtest.php in the browser.
I am getting an error msg as " Client does not support authentication protocol requested by server; consider upgrading MySQL client".
where do u think the problem lies?? I want to make sure that am i following the right direction.Am i missing something that still need to done??
I know this may sound basic but i really do not have any clue about this.Can someone help me ,please !!!
Any sugggestion or advice is appreicated.If anybody could help,please let me know.
Thanks in advance..
Cheers,
VG
Unsolved 
