: Restrict Plesk user for external developer access We are commissioning an external developer to develop part of our site and he will also need access to a MySQL database attached to the domain

@Si4351233

If you don't want him to have direct access to the Plesk panel then the easiest way would be to give him an FTP user account and define a new MySQL user account with remote access granted that way he can use the MySQL Desktop Application to get into the MySQL database to manage the schema. Once he has finished his work you can disable remote access to the database and disable his MySQL and FTP account to return to a secured environment. When you create his user account for MySQL simply give him access to the database he is needing access to and not to any other database or to MySQL administrative controls and that way you can maintain the security while giving him access and not requiring him to have access to Plesk. If you desperately need him to have access to phpMyAdmin instead of using the desktop MySQL interface then he will need Plesk access but in my opinion as someone who has done database design on a contract basis it is preferable to be granted remote access through the desktop tool instead of needing to log into the control panel and into phpMyAdmin as the experience is faster, more streamlined, and I can save the login details to re-access as often as I need to as part of the contract without needing to save the password to the browser or searching records to locate the password every time I need to login.

Vote Up Vote Down