After upgrading to Tiger, I am having touble with my MySQL database. I have done research on this problem, and found several answers, but I cannot seem to implement them correctly.
I get the following error.
""Client does not support authentication protocol requested by server; consider upgrading MySQL client"
After researching this problem, I understand why this is happening. I have found this fix that seems to work for pretty much everyone (except me of course).
"mysql> SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('newpwd');"
I am not very famaliar with using the Terminal at all. So, I can't get this command to work correctly.
Can some one please show me how to implement this fix from sratch. (Even how to get to the 'mysql>' prompt for that command.)
I appreciate all of you help!
Thanks!
mark