MySQL Connect using Dreamweaver

------=_NextPart_000_0034_01C5CFC6.3BA5E810
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Dear All,

I have installed MySQL 5 with PHP 4.3.3.

When trying to connect to a database form the 'Database' tab in =
Dreamweaver, I now get the following error when trying to select a DB:

'1251 Client does not support authentication protocol requested by =
server; consider upgrading MySQL client'

Regards,

Will
------=_NextPart_000_0034_01C5CFC6.3BA5E810--

RE: MySQL Connect using Dreamweaver

That's a very common one. You're on windows, right?
Try putting in "consider upgrading MySQL client" into google. The first one
I found was this one:

http://www.experts-exchange.com/Web/Web_Languages/PHP/PHP_Wi ndows/Q_21252231
..html

Although the guy first claims it's not the OLD_PASSWORD problem, believe me,
it is.

Alternatively look up the error code, although I don't know if that would've
helped in this case.

-----Original Message-----
From: W Roothman [mailto:willows@telkomsa.net]
Sent: 13 October 2005 06:18
To: php-db@lists.php.net
Subject: [PHP-DB] MySQL Connect using Dreamweaver


Dear All,

I have installed MySQL 5 with PHP 4.3.3.

When trying to connect to a database form the 'Database' tab in Dreamweaver,
I now get the following error when trying to select a DB:

'1251 Client does not support authentication protocol requested by server;
consider upgrading MySQL client'

Regards,

Will

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: MySQL Connect using Dreamweaver

Hi. You must use mysqli which is only supported in php5. Of corse if you
will use MySQL5.

regards

W Roothman wrote:
> Dear All,
>
> I have installed MySQL 5 with PHP 4.3.3.
>
> When trying to connect to a database form the 'Database' tab in Dreamweaver, I now get the following error when trying to select a DB:
>
> '1251 Client does not support authentication protocol requested by server; consider upgrading MySQL client'
>
> Regards,
>
> Will

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Re: MySQL Connect using Dreamweaver

--------------030003070103090403030703
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Correct me if I'm wrong, but if I'm not mistaken Mysql 5 will not work
in Dreamweaver.

It will only work if you have 4.x (can't remember the exact version)

Even if you have installed Mysql 4.x, u must make sure you add in
old_password at the last line of the my.cnf
If not, you can always update all the passwords for all the user
accounts in your Mysql server by using old_password() function.

e.g.
use mysql; update user set password=old_password('abc123') where
host='localhost', user='root';

Blaz wrote:

> Hi. You must use mysqli which is only supported in php5. Of corse if
> you will use MySQL5.
>
> regards
>
> W Roothman wrote:
>
>> Dear All,
>>
>> I have installed MySQL 5 with PHP 4.3.3.
>>
>> When trying to connect to a database form the 'Database' tab in
>> Dreamweaver, I now get the following error when trying to select a DB:
>>
>> '1251 Client does not support authentication protocol requested by
>> server; consider upgrading MySQL client'
>>
>> Regards,
>>
>> Will
>
>



--------------030003070103090403030703
Content-Type: text/plain; charset=us-ascii

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--------------030003070103090403030703--

Re: Re: MySQL Connect using Dreamweaver

You have to change the password hash to the old 3.23.x format if you
don't want or can't use mysqli. Open a mysql shell and type something
like:

use mysql;
UPDATE user SET password = OLD_PASSWORD('yourpass') WHERE user =
'youruser' AND host = 'localhost';

On Thu, 2005-10-13 at 08:23 +0200, Blaz wrote:
> Hi. You must use mysqli which is only supported in php5. Of corse if you
> will use MySQL5.
>
> regards
>
> W Roothman wrote:
> > Dear All,
> >
> > I have installed MySQL 5 with PHP 4.3.3.
> >
> > When trying to connect to a database form the 'Database' tab in Dreamweaver, I now get the following error when trying to select a DB:
> >
> > '1251 Client does not support authentication protocol requested by server; consider upgrading MySQL client'
> >
> > Regards,
> >
> > Will
>

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: MySQL Connect using Dreamweaver

try downloading the mysqli library (perhaps by grabbing all of version 5)
and copying that into the extension folder for your 4.3.3 install of
PHP...add the below line to the ini file :

extension=php_mysqli.dll


bastien

>From: "W Roothman"
>Reply-To: "W Roothman"
>To:
>Subject: [PHP-DB] MySQL Connect using Dreamweaver
>Date: Thu, 13 Oct 2005 07:17:56 +0200
>
>Dear All,
>
>I have installed MySQL 5 with PHP 4.3.3.
>
>When trying to connect to a database form the 'Database' tab in
>Dreamweaver, I now get the following error when trying to select a DB:
>
>'1251 Client does not support authentication protocol requested by server;
>consider upgrading MySQL client'
>
>Regards,
>
>Will

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Re: MySQL Connect using Dreamweaver

Will,

is mysql installed on your local machine or on a different server? Do
you work with root or with a newly created user?
If mysql is not installed on your local machine, you have to grant
access from other machines to your database. Here's an example (with a
newly created user).

Example:
your work machine's IP: 192.168.0.25
your username: will

open a mysql shell (with root/superuser privileges) and type:

GRANT ALL PRIVILEGES ON *.* TO 'will'@'192.168.0.25' IDENTIFIED BY
'mysecretpassword';

use mysql;

UPDATE user SET password = OLD_PASSWORD('mysecretpassword') WHERE user =
'will' AND host = '192.168.0.25';

FLUSH PRIVILEGES;

quit;

if your database runs on the same system as Dreamweaver, replace
192.168.0.25 with localhost and it should (hopefully) work.

regards
Sascha

On Thu, 2005-10-13 at 16:35 +0200, W Roothman wrote:
> Dear Sascha, Mathias, Blaz
>
> Thanks, Sacha it worked, the AND localhost='localhost' did it, but my
> new error now is
>
> 'localhost not allowed to connect to this MySQL server'
>
> grrrr...
>
> R's,
>
> Will
> ----- Original Message -----
> From: Sascha Kaufmann
> To: php-db@lists.php.net
> Sent: Thursday, October 13, 2005 9:46 AM
> Subject: Re: [PHP-DB] Re: MySQL Connect using Dreamweaver
>
>
> You have to change the password hash to the old 3.23.x format
> if you
> don't want or can't use mysqli. Open a mysql shell and type
> something
> like:
>
> use mysql;
> UPDATE user SET password = OLD_PASSWORD('yourpass') WHERE user
> =
> 'youruser' AND host = 'localhost';
>
> On Thu, 2005-10-13 at 08:23 +0200, Blaz wrote:
> > Hi. You must use mysqli which is only supported in php5. Of
> corse if you
> > will use MySQL5.
> >
> > regards
> >
> > W Roothman wrote:
> > > Dear All,
> > >
> > > I have installed MySQL 5 with PHP 4.3.3.
> > >
> > > When trying to connect to a database form the 'Database'
> tab in Dreamweaver, I now get the following error when trying
> to select a DB:
> > >
> > > '1251 Client does not support authentication protocol
> requested by server; consider upgrading MySQL client'
> > >
> > > Regards,
> > >
> > > Will
> >
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Re: MySQL Connect using Dreamweaver

------=_NextPart_015_ecb1_3da2444c.0a9c2275_.MIX
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Will,

is mysql installed on your local machine or on a different server? Do
you work with root or with a newly created user?
If mysql is not installed on your local machine, you have to grant
access from other machines to your database. Here's an example (with a
newly created user).

Example:
your work machine's IP: 192.168.0.25
your username: will

open a mysql shell (with root/superuser privileges) and type:

GRANT ALL PRIVILEGES ON *.* TO 'will'@'192.168.0.25' IDENTIFIED BY
'mysecretpassword';

use mysql;

UPDATE user SET password =3D OLD_PASSWORD('mysecretpassword') WHERE user=
=3D
'will' AND host =3D '192.168.0.25';

FLUSH PRIVILEGES;

quit;

if your database runs on the same system as Dreamweaver, replace
192.168.0.25 with localhost and it should (hopefully) work.

regards
Sascha

On Thu, 2005-10-13 at 16:35 +0200, W Roothman wrote:
> Dear Sascha, Mathias, Blaz
> =20
> Thanks, Sacha it worked, the AND localhost=3D'localhost' did it, but m=
y
> new error now is=20
> =20
> 'localhost not allowed to connect to this MySQL server'
> =20
> grrrr...
> =20
> R's,
> =20
> Will
> ----- Original Message -----=20
> From: Sascha Kaufmann=20
> To: php-db@lists.php.net=20
> Sent: Thursday, October 13, 2005 9:46 AM
> Subject: Re: [PHP-DB] Re: MySQL Connect using Dreamweaver
> =20
> =20
> You have to change the password hash to the old 3.23.x format
> if you
> don't want or can't use mysqli. Open a mysql shell and type
> something
> like:
> =20
> use mysql;
> UPDATE user SET password =3D OLD_PASSWORD('yourpass') WHERE us=
er
> =3D
> 'youruser' AND host =3D 'localhost';
> =20
> On Thu, 2005-10-13 at 08:23 +0200, Blaz wrote:
> > Hi. You must use mysqli which is only supported in php5. Of
> corse if you=20
> > will use MySQL5.
> >=20
> > regards
> >=20
> > W Roothman wrote:
> > > Dear All,
> > >=20
> > > I have installed MySQL 5 with PHP 4.3.3.
> > >=20
> > > When trying to connect to a database form the 'Database'
> tab in Dreamweaver, I now get the following error when trying
> to select a DB:
> > >=20
> > > '1251 Client does not support authentication protocol
> requested by server; consider upgrading MySQL client'
> > >=20
> > > Regards,
> > >=20
> > > Will
> >=20
> =20
> --=20
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> =20
> =20

--=20
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




************************************************************ **********

IMPORTANT NOTICE

This communication is for the exclusive use of the intended recipient(s)
named above. If you receive this communication in error, you should
notify the sender by e-mail or by telephone (+44) 191 224 4461, delete
it and destroy any copies of it.

This communication may contain confidential information and material
protected by copyright, design right or other intellectual property
rights which are and shall remain the property of Piranha Studios
Limited. Any form of distribution, copying or other unauthorised use
of this communication or the information in it is strictly prohibited.
Piranha Studios Limited asserts its rights in this communication and
the information in it and reserves the right to take action against
anyone who misuses it or the information in it.

Piranha Studios Limited cannot accept any liability sustained as a
result of software viruses and would recommend that you carry out your
own virus checks before opening any attachment.

************************************************************ ************
<<<>>>
------=_NextPart_015_ecb1_3da2444c.0a9c2275_.MIX
Content-Type: text/plain;
name="GWAVADAT.TXT"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment; filename="GWAVADAT.TXT"

AdmID:5AA139178E47E004D7D6F2507D379407



************************************************************ **********

IMPORTANT NOTICE

This communication is for the exclusive use of the intended recipient(s)
named above. If you receive this communication in error, you should
notify the sender by e-mail or by telephone (+44) 191 224 4461, delete
it and destroy any copies of it.

This communication may contain confidential information and material
protected by copyright, design right or other intellectual property
rights which are and shall remain the property of Piranha Studios
Limited. Any form of distribution, copying or other unauthorised use
of this communication or the information in it is strictly prohibited.
Piranha Studios Limited asserts its rights in this communication and
the information in it and reserves the right to take action against
anyone who misuses it or the information in it.

Piranha Studios Limited cannot accept any liability sustained as a
result of software viruses and would recommend that you carry out your
own virus checks before opening any attachment.

************************************************************ ************
<<<>>>

------=_NextPart_015_ecb1_3da2444c.0a9c2275_.MIX
Content-Type: text/plain; charset=us-ascii

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
------=_NextPart_015_ecb1_3da2444c.0a9c2275_.MIX--