I haven't upgraded my mysql music, I didn't think I just upgraded, I checked it out to check it out, I was like this, Mysql 4.1 and Udeses An Authentication Protocol Based ON A Password Hashing Algorithm That INCOMPATINTHINGORITHM That INCOMPATible with That Used by Older Clients. ... .
Please use one of the following two methods
One:
Mysql> Set Password for
-> 'some_user' @ 'Some_host' = Old_Password ('newpwd');
Two:
mysql> update mysql.user set password = Old_password ('newpwd')
-> Where host = 'some_host' and user = 'some_user';
mysql> flush privileges;