Re: Re: MySQL Connect using Dreamweaver
| From: | Shahmat Dahlan | Date: | Thu, 13 Oct 2005 06:53:01 +0000 |
| Subject: | Re: Re: MySQL Connect using Dreamweaver | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-40507@lists.php.net to get a copy of this message | ||
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