How to get MySQL to work with PHP?

[Marcel]

Hi,
I'm trying to set up a connection to MySQL on my home network.
MySQL seems to be working all right, I've created accounts, databases and
tables, etc.

PHP-version 4.3.9, and according to phpinfo() no configure command.

If I execute the command:

$db = mysql_connect ('localhost', 'root', 'xxxxxx') or die ("Unable to
connect to Database Server");

then the following error message appears:

Warning: mysql_connect(): Client does not support authentication protocol
requested by server; consider upgrading MySQL client in test.php on line 3
Unable to connect to Database Server.

Suggestions please, Marcel

[Andy Hassall]

On Sat, 04 Dec 2004 00:45:24 GMT, "Marcel" <in**@nospam-bluegumdata.com.au>
wrote:

Hi,
I'm trying to set up a connection to MySQL on my home network.
MySQL seems to be working all right, I've created accounts, databases and
tables, etc.

PHP-version 4.3.9, and according to phpinfo() no configure command.

If I execute the command:

$db = mysql_connect ('localhost', 'root', 'xxxxxx') or die ("Unable to
connect to Database Server");

then the following error message appears:

Warning: mysql_connect(): Client does not support authentication protocol
requested by server; consider upgrading MySQL client in test.php on line 3
Unable to connect to Database Server.

Suggestions please, Marcel

http://www.google.com/search?hl=en&c...col%22&spell=1

--
Andy Hassall / <an**@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool

[Marcel]

Thank you, I had seen the suggestion of resetting the password to 'pre
4.1-style', but since I'm using 4.1.7 myself, I thought it wasn't the answer
to my particular problem...

"Andy Hassall" <an**@andyh.co.uk> wrote in message
news:ig********************************@4ax.com...

On Sat, 04 Dec 2004 00:45:24 GMT, "Marcel" <in**@nospam-bluegumdata.com.au> wrote:

Hi,
I'm trying to set up a connection to MySQL on my home network.
MySQL seems to be working all right, I've created accounts, databases and
tables, etc.

PHP-version 4.3.9, and according to phpinfo() no configure command.

If I execute the command:

$db = mysql_connect ('localhost', 'root', 'xxxxxx') or die ("Unable to
connect to Database Server");

then the following error message appears:

Warning: mysql_connect(): Client does not support authentication protocolrequested by server; consider upgrading MySQL client in test.php on line 3Unable to connect to Database Server.

Suggestions please, Marcel

http://www.google.com/search?hl=en&c...refox-a&rls=or
g.mozilla:en-US:official&q=%22client+does+not+support+authentic ation+protoco
l%22&spell=1
--
Andy Hassall / <an**@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool