Not hard to do.. 1st, he'll need to port forward his mysql port to the database box from the router (3306 most of the time). Then, he'll need to set the username/password up in mysql to accept connections from any ip address, or your specfic ip address.
You can get instructions on the usage of the mysql GRANT system in the mysql docs at
www.mysql.com