Re: [PHP-DB] Re: MySQL Connect using Dreamweaver

2005-10-13 Thread Shahmat Dahlan
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






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

Re: [PHP-DB] Re: MySQL Connect using Dreamweaver

2005-10-13 Thread skaufmann
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'
>  
> g...
>  
> 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




**

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.


<<<>>>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 t

Re: [PHP-DB] Re: MySQL Connect using Dreamweaver

2005-10-13 Thread Sascha Kaufmann
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'
>  
> g...
>  
> 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: [PHP-DB] Re: MySQL Connect using Dreamweaver

2005-10-13 Thread Sascha Kaufmann
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