mysql_connect not working ?

[Tony Benham]

I'm using apache 1.3.28 php 4.3.9 mysql 4.1 on my machine which runs
win2000.
I can connect to the apache server from a browser, and run a script with
phpinfo included which tells me mysql support is installed.
I can run mysql from the command console, and create databases/tables etc.
However when I try to connect to mysql from a php script, mysql_connect
cannot connect to mysql.
The function returns false.
Any ideas how I can see what is happening, or what might be wrong ?
Regards
Tony



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system ([url]http://www.grisoft.com[/url]).
Version: 6.0.771 / Virus Database: 518 - Release Date: 28/09/2004

[iuz]

Tony Benham wrote:

> I'm using apache 1.3.28 php 4.3.9 mysql 4.1 on my machine which runs
> win2000.
> I can connect to the apache server from a browser, and run a script with
> phpinfo included which tells me mysql support is installed.
> I can run mysql from the command console, and create databases/tables etc.
> However when I try to connect to mysql from a php script, mysql_connect
> cannot connect to mysql.
> The function returns false.
> Any ideas how I can see what is happening, or what might be wrong ?
> Regards
> Tony
>
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system ([url]http://www.grisoft.com[/url]).
> Version: 6.0.771 / Virus Database: 518 - Release Date: 28/09/2004

can you post the code that return the error?!

--
[url]www.iuz-lab.info[/url]

[Tony Benham]

Hi,
The code is very simple
@ $db = mysql_connect('localhost', 'username', 'password');

if (!$db)

{

echo 'Error: Could not connect to database, Please try again later.';

exit;

}

Tony

"iuz" <user@host.network> wrote in message
news:oFV8d.73615$35.3739320@news4.tin.it...

> Tony Benham wrote:
>

> > I'm using apache 1.3.28 php 4.3.9 mysql 4.1 on my machine which runs
> > win2000.
> > I can connect to the apache server from a browser, and run a script with
> > phpinfo included which tells me mysql support is installed.
> > I can run mysql from the command console, and create databases/tables

etc.

> > However when I try to connect to mysql from a php script, mysql_connect
> > cannot connect to mysql.
> > The function returns false.
> > Any ideas how I can see what is happening, or what might be wrong ?
> > Regards
> > Tony
> >
> >
> >
> > ---
> > Outgoing mail is certified Virus Free.
> > Checked by AVG anti-virus system ([url]http://www.grisoft.com[/url]).
> > Version: 6.0.771 / Virus Database: 518 - Release Date: 28/09/2004

>
> can you post the code that return the error?!
>
> --
> [url]www.iuz-lab.info[/url]

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system ([url]http://www.grisoft.com[/url]).
Version: 6.0.771 / Virus Database: 518 - Release Date: 28/09/2004

[Virgil Green]

"Tony Benham" <tonyb@kerrisway.freeserve.co.uk> wrote in message
news:2sio28F1limqaU1@uni-berlin.de...

> Hi,
> The code is very simple
> @ $db = mysql_connect('localhost', 'username', 'password');

After this, put:
if (mysql_errno()) echo mysql_errno() . ':' . mysql_error() . '<br>';

and see if that tells you what is wrong.

> if (!$db)
>
> {
>
> echo 'Error: Could not connect to database, Please try again later.';
>
> exit;
>
> }
>
> Tony

[Tony Benham]

Hi,
I switched error reporting on ,and got the following error.
Warning: mysql_connect(): Client does not support authentication protocol
requested by server; consider upgrading MySQL client in results.php on line
23
I can connect from the mysql monitor wiithout any problem.
Any ideas what this is ?
Tony


"Tony Benham" <tonyb@kerrisway.freeserve.co.uk> wrote in message
news:2sio28F1limqaU1@uni-berlin.de...

> Hi,
> The code is very simple
> @ $db = mysql_connect('localhost', 'username', 'password');
>
> if (!$db)
>
> {
>
> echo 'Error: Could not connect to database, Please try again later.';
>
> exit;
>
> }
>
> Tony
>
> "iuz" <user@host.network> wrote in message
> news:oFV8d.73615$35.3739320@news4.tin.it...

> > Tony Benham wrote:
> >

> > > I'm using apache 1.3.28 php 4.3.9 mysql 4.1 on my machine which runs
> > > win2000.
> > > I can connect to the apache server from a browser, and run a script

with

> > > phpinfo included which tells me mysql support is installed.
> > > I can run mysql from the command console, and create databases/tables

> etc.

> > > However when I try to connect to mysql from a php script,

mysql_connect

> > > cannot connect to mysql.
> > > The function returns false.
> > > Any ideas how I can see what is happening, or what might be wrong ?
> > > Regards
> > > Tony
> > >
> > >
> > >
> > > ---
> > > Outgoing mail is certified Virus Free.
> > > Checked by AVG anti-virus system ([url]http://www.grisoft.com[/url]).
> > > Version: 6.0.771 / Virus Database: 518 - Release Date: 28/09/2004

> >
> > can you post the code that return the error?!
> >
> > --
> > [url]www.iuz-lab.info[/url]

>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system ([url]http://www.grisoft.com[/url]).
> Version: 6.0.771 / Virus Database: 518 - Release Date: 28/09/2004
>
>

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system ([url]http://www.grisoft.com[/url]).
Version: 6.0.771 / Virus Database: 518 - Release Date: 28/09/2004

[Tony Benham]

Hi,
I found the error was the new password hashing algorithm in MySQL4.1 up.
PHP4.3.9 I guess uses the old algorithm. Anyway I set 4.1 to use the old
style passwords and it's now fine.
Thanks for the help.
Tony

"Virgil Green" <vjg@DESPAMobsydian.com> wrote in message
news:SxW8d.1575$Lk3.597@newssvr12.news.prodigy.com ...

> "Tony Benham" <tonyb@kerrisway.freeserve.co.uk> wrote in message
> news:2sio28F1limqaU1@uni-berlin.de...

> > Hi,
> > The code is very simple
> > @ $db = mysql_connect('localhost', 'username', 'password');

>
> After this, put:
> if (mysql_errno()) echo mysql_errno() . ':' . mysql_error() . '<br>';
>
> and see if that tells you what is wrong.
>

> > if (!$db)
> >
> > {
> >
> > echo 'Error: Could not connect to database, Please try again later.';
> >
> > exit;
> >
> > }
> >
> > Tony

>
>
>

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system ([url]http://www.grisoft.com[/url]).
Version: 6.0.771 / Virus Database: 518 - Release Date: 28/09/2004