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

Question

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 updating mysqldump (since I don't have access to it)?

Answer 1

I actually had a similar issue. I found that running the command directly from the command line worked, but using their cron system did not. I solved this by sticking the following command in a shell script and scheduling that to run:

mysqldump --add-drop-tables -u (dbusername) -p(dbpassword) -h (dbhost) (db) > Output.sql