mysql-error-1251

GoDaddy's MySQL dump isn't compatible with server (error 1251)

I've a problem when trying to run mysqldump using the cron manager in GoDaddy's hosting interface. It spew out: Got error: 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client when trying to connect Anyone ever have the same problem? Is there a solution that doesn't involve updatin...

What is wrong with this format

SELECT .... GROUP BY c.city_id ORDER BY p.name desc UNION SELECT ... GROUP BY c.city_id, p ERROR 1221 (HY000): Incorrect usage of UNION and ORDER BY is there a way to have this format because i want the top query to have an orderby do i need to have the same orderby on the bottom query ...