How can I give someone server access to only duplicate and modify a site?

Well, you can use a plugin like Duplicator to create an installer package of the complete site including database etc. which the user then can install in a new database & website path.

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)