MySQL Forums
Forum List  »  PHP

New to My SQL - MySQL Connection Problem
Posted by: Bill Welsh
Date: August 21, 2005 01:39PM

Hi All,

I quite new to all this web stuff but I have an IT background 360/370 ICL 1900 TI990 PC generally using assembler COBOL or xbase etc.

I am attempting to use PHP to access MySQL via a local server (Intranet)!?

I have installed the following on my PC

Apache ver 2.0.54 (WIN32)
MySQL ver 4.1.13a-nt via TCP/IP
PHP ver 4.4.0

I've written a tiny php file see listing below. This runs in my browser (Opera) OK.
but I get the following error message when attempting to connect to MySQL

"Client does not support authentication protocol requested by server, consider upgrading MySQL client"

Here's the code

<html>
<head>
<title>PHP MySQL Test Script Raw state No Dreamweaver</title>
</head>
<body>
<?php
echo $_SERVER['HTTP_USER_AGENT</p>'];
$host = "localhost";
$username = "root";
$password = "111111";
$database = "test";
$server = mysql_connect($host, $username, $password) or die(mysql_error());
$connection = mysql_select_db($database, $server);
mysql_close($server);
?>
</body>
</html>


Can anybody help

Many thanks in advance

Bill

Options: ReplyQuote


Subject
Written By
Posted
New to My SQL - MySQL Connection Problem
August 21, 2005 01:39PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.