Re: [PHP-DB] Re: MySQL Connect using Dreamweaver
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
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
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
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