My Snippets

rsync -av --exclude folder-to-remove source-folder user@host:destination-folder e.g. rsync -av --exclude child /var/www/parent root@192.168.167.1:/home/www

rsync filename username@hostname:path e.g. rsync ab.txt root@192.168.167.1:/home/www

Command find -name abc*

On Mysql Command Prompt: mysql> USE mysql; mysql> DROP USER 'username'@'hostname';

On Mysql command prompt mysql> USE mysql; mysql> CREATE USER 'username'@'hostname' IDENTIFIED BY 'password'; mysql> GRANT ALL ON databasename1.* TO 'username'@'hostname';  mysql> GRANT SELECT ON databasename2.table TO 'username'@'hostname';  mysql> GRANT USAGE ON *.* TO 'username'@'hostname' WITH MAX_QUERIES_PER_HOUR 90;