Mysql 4.1 and Dreamweaver

[maccman]

I'm having trouble connecting to a mysql 4.1 database using dreamweaver. When
ever I try and do so a message says that the application cannot authorise
itself. I've used dreamweaver with earlier versions of mysql. Is there any way
round this?
Thanks

Visit [url]http://www.alexmaccaw.co.uk[/url] for quality websites

[David Powers]

maccman wrote:

> I'm having trouble connecting to a mysql 4.1 database using dreamweaver. When
> ever I try and do so a message says that the application cannot authorise
> itself. I've used dreamweaver with earlier versions of mysql. Is there any way
> round this?

The password encryption system was changed in MySQL 4.0, so if you are
using previous data migrated from an earlier version of MySQL, you will
need to update the grants tables. Instructions are in the MySQL
documentation at

[url]http://dev.mysql.com/doc/mysql/en/upgrading-grant-tables.html[/url]

MySQL 4.1 requires more up to date code libraries. You may also need to
update your version of PHP.

--
David Powers
Author, "Foundation PHP 5 for Flash" (friends of ED)
Co-author "PHP Web Development with DW MX 2004" (Apress)
[url]http://computerbookshelf.com[/url]