I can't connect on my computer using the 'root' superuser with a password
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! :'(