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
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.