After I have installed mySQL 4.1 on WinXP, what should the 'user' table look like? Viewing the user table in the command line client, I am seeing two users: both @, one of them root@localhost and the other does not specify a user. I am able to connect to MySQL in php as long as I don't specify a user and password. However, when I try to connect using 'root' as the user and my root password, which is the same one that I am successfully using to login to the command line client, I get the following error:
Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in ...
Is this something to do with password hashing? Any suggestions?
Any feedback is greatly appreciated!
