@whackowebmaster MySQL databases cannot be accessed using FTP. You will have to provide him with cPanel access. As you have a VPS & you hold the root password, the outsourcer will have access to that specific cPanel account and nothing else.
Once he is done with performing the work, change the cPanel account password. Doing this, he will not be able to gain account access unless you provide him with new password.