I currently have a website that has been recently completed. I'm contemplation using a freelance service such as SO for all future components. There is a considerable amount of work to be completed on-top of the existing infrastructure.

I've tried searching for an answer to this question, but it's so generic in terms that it's difficult.

My site is fairly complex using relational databases, MySQL, PHP, Javascript, JQuery, and Ajax.

I'm concerned about using a freelance worker on the site in regards to giving them admin access to the server and allowing them to access the existing databases. Is there a tried and true way to handle / manage this? I'm open to allowing it, but what safety precautions and other ideas do you have to prevent mischief?


I suggest making a clone in a development environment to minimize damage if something does happen, intentional or not.

Otherwise, make sure to use ftp/database passwords that are unique to this project only. Make a full site backup including files, settings, and database.

I agree with Shark that you don't want to hinder work performance with extreme security measures. In the end its all up to you and how important this data is. There may be some better solutions that require some time and resources if you have them, but I am under the impression you just want to get the damn thing up and running.

  • Indeed, testing environments for the win. I know I don't trust myself or my colleagues with deployment, so we use source control, testing environments and code reviews to make sure what goes live is checked by enough eyeballs. – André Caron Nov 11 '11 at 3:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy