I have several wordpress sites that I have setup locally to use the remote mysql db. This helps avoid duplication in your testing and production environments.
Since upgrading to Snow Leopard the ability to connect to remote dbs has been obliterated. I found an explanation on stack over flow:
"I have resolved this. The issue indeed was due to Snow Leopard’s default of using mysqlnd as the module for PHP 5.3 it ships with, not with Dreamhost. That module flatly refuses to connect with servers using OLD_PASSWORD hash.
The only solution to this (as I can’t change MySQL settings on shared hosting) is to recompile your own PHP, that will not use mysqlnd but mysql/mysqli."
I am asking here to see if anyone else has had this problem and foudn an easier solution than recompiling php.