Mysql password hashing method old vs new

I’m trying to connect to a mysql server at dreamhost from a php scrip located in a server at slicehost (two different hosting companies).
I need to do this so I can transfer new data at slicehost to dreamhost. Using a dump is not an option because the table structures are different and i only need to transfer a small subset of data (100-200 daily records)
The problem is that I’m using the new MySQL Password Hashing method at slicehost, and dreamhost uses the old one, So i get

How do I use password hashing with PDO to make my code more secure?

My code is actually working but it’s not at all secure, I don’t want to use MD5 as it’s not all that secure. I’ve been looking up password hashing but I’m not sure how I would incorporate it into my code. Login: require_once __DIR__.'/config.php'; session_start(); $dbh = new PDO('mysql:host=' . DB_HOST . ';dbname=' . DB_USERNAME, … Read more