error in connecting MySql and PHPBB help me.....

Do you have the GUI MySQL Administrator? If not download it.

Log in to the Administrator. On the left side choose startup variables. Then on the right side at the top choose the security tab. Click on 'Use old qasswords'. Then restart your MySQL Instance. You may also need to create another database...

Hope this helps.

sorry frnd it's giving same error again.
I installed tht i changed tht to oldpasswords and i creates a schema "forums" and i had given
Database Type: MySql 4.X
Database Server Hostname / DSN: localhost
Your Database Name: forums
Database Username: root
Database Password: *****
Prefix for tables in database: phpbb_
for sever port i chked for 80 & 3306 nothing i got
Ok any way Thanx for ur response, Is there any other alternative???

mysql4.X is installed on my system.while i tried to install Phpbb forums in my personal computer it is giving the following error:
Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\Program Files\Apache Group\Apache2\htdocs\phpBB2\db\mysql4.php on line 48

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in C:\Program Files\Apache Group\Apache2\htdocs\phpBB2\db\mysql4.php on line 330

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in C:\Program Files\Apache Group\Apache2\htdocs\phpBB2\db\mysql4.php on line 331
phpBB : Critical Error

Could not connect to the database

can any one help..... plz

There is a really good step by step guide at http://www.pluckypigeon.com/phpbb.html that should help you out