通过myodbc无法链接至MySQL的错误：
Client does not support authentication protocol requested
by server; consider upgrading MySQL client
官方的说法是
MySQL 4.1 and up uses an authentication protocol based on a password hashing algorithm that is incompatible with that used by older clients. .....

网上的解决办法：

参考：http://www.cnblogs.com/yongzhi/articles/1360444.html

试验后，发现：

安装的myodbc版本3.51-07

更新到3.51-11，问题解决，不需要其他设置。