Hi Guys,

I've been using PHP with MySQL for about a year now and it's been really nice. I have this problem connecting PHP with MySQL when I assign a password to the root account. It gives me the following error message:

Client does not support authentication protocol requested by server, consider upgrading MySQL client.

I am making use of the version 5 of MySQL and I wonder what the problem is? The problem does not arise when there's no password for the 'root' account.

I'll appreciate a hand in this problem that has been bothering me! :'(