| Sascha Kaufmann 2005-10-13, 6:56 pm |
| 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:
> corse if you
> tab in Dreamweaver, I now get the following error when trying
> to select a DB:
> requested by server; consider upgrading MySQL client'
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
|