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 but I can't figure out how to create a user that has the least required privileges for him to do his work.
I only want to allow phpMyAdmin access to the database as well as FTP access to the website directory. When I create a database and user, phpMyAdmin sits behind Plesk, requiring a Plesk user account to log in.
I don't want to grant the developer any access beyond FTP and MySQL/phpMyAdmin. Is this not possible without creating some kind of Plesk user?
And what do I do to limit that Plesk user's privileges? The privileges grantable in Plesk are rather liberal and not granular enough it seems.
- Windows 2008 Server
- Plesk 11.5.3
- Running on a VPS