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
