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]

Re: How to get MySQL to work with PHP?

On Sat, 04 Dec 2004 00:45:24 GMT, "Marcel" <info@nospam-bluegumdata.com .au>
wrote:
[color=blue]
>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[/color]

http://www.google.com/search?hl=en&c2coff=1&safe=off&client=firefox-a&rls=org.mozilla:en-US:official&q=%22client+does+not+support+authentication+protocol%22&spell=1

--
Andy Hassall / <andy@andyh.co. uk> / <http://www.andyh.co.uk >
<http://www.andyhsoftwa re.co.uk/space> Space: disk usage analysis tool

[Marcel]

Re: How to get MySQL to work with PHP?

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" <andy@andyh.co. uk> wrote in message
news:ig22r0htkp 267k4ud0ei5eb8k u8s8v87t9@4ax.c om...[color=blue]
> On Sat, 04 Dec 2004 00:45:24 GMT, "Marcel"[/color]
<info@nospam-bluegumdata.com .au>[color=blue]
> wrote:
>[color=green]
> >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[/color][/color]
protocol[color=blue][color=green]
> >requested by server; consider upgrading MySQL client in test.php on line[/color][/color]
3[color=blue][color=green]
> >Unable to connect to Database Server.
> >
> >Suggestions please, Marcel[/color]
>
>[/color]

http://www.google.com/search?hl=en&c2coff=1&safe=off&client=firefox-a&rls=or

g.mozilla:en-US:official&q=% 22client+does+n ot+support+auth entication+prot oco
l%22&spell=1[color=blue]
>
> --
> Andy Hassall / <andy@andyh.co. uk> / <http://www.andyh.co.uk >
> <http://www.andyhsoftwa re.co.uk/space> Space: disk usage analysis tool[/color]