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: [email protected]
> 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
