MYSQL

Login: List databases: Delete database: Make new database: Make new user: List users: Delete user: Gives all rights to user over a certain database (replace database.name with * for all databases): Refreshes privileges, a must after a change: Lists user rights: Exports (dumps) the database: Shows original (exported) database name: Imports dump of some database … Read moreMYSQL

Rsync

Copies files from a source to destination. Syncs directories without copying already existing files and updating modified files. Works over SSH. remote -> local: local -> local: local -> remote: Options/flags: -a -a equals to use of following options -rlptgoD recursively copy files and directories copy symlinks as symlinks preserve permissions preserve group preserve modification … Read moreRsync

Screen

Screen tool is very useful if you need to disconnect from remote server, or you have a shaky connection that tends to drop but the started process on remote server needs to continue. You can reconnect later and any process started in screen session continues while you are disconnected. You are able to resume that … Read moreScreen

Tested on Ubuntu & Pop OS