Open Source - Tipps and Tutorials

Never use your root account and password when running databases. The root account is a privileged account which should only be used for admin procedures.

And also unadvisable to add global MySQL server privileges to those database users who connect to a MySQL database from an application/script (Joomla, Drupal, etc). Better if you setup these users separated to one database with database specific privileges.

You can add users to a MySQL database by using a control panel like phpMyAdmin to easily create or assign database permissions for users.

To set up a restricted sftp server you should use the "ForceCommand" and "ChrootDirectory" directives in sshd_config.
If you don't want to restrict every user, you should also use the "Match" directive to select user(s) or group(s) to apply the restrictions to.
Because of security, sshd ensures the "ChrootDirectory" and each of its components is root-owned and not writable by other users.
So you have to create a new directory within the "ChrootDirectory" what is owned by the restricted user.

If you want to connect to a remote machine's OpenSSH server from your locale Debian machine using Terminal, Nautilus or GFTP, you must have the openssh-client

This package provides the ssh, scp and sftp clients, the ssh-agent and ssh-add programs to make public key authentication more convenient, and the ssh-keygen, ssh-keyscan, ssh-copy-id and ssh-argv0 utilities.