MySQL add user, grant privileges

Short tutorial on how to create a new user (line1) and allowing him different rights on a whole database or a single table (see examples line2-3-4).

CREATE USER 'jeffrey'@'localhost' IDENTIFIED BY 'mypass';
GRANT ALL ON db1.* TO 'jeffrey'@'localhost';
GRANT SELECT ON db2.invoice TO 'jeffrey'@'localhost';
GRANT USAGE ON *.* TO 'jeffrey'@'localhost' WITH MAX_QUERIES_PER_HOUR 90;

screen configuration file

Screen is a powerful utility to have multiple terminal opened. It’s handy to write a configuration file to add a status bar listing all terminal opened (like the taskbar of visual environments), and that dock to F11 and F12 (instead of F1 and F2) the shortcuts for next/previous screen. Here how to do:  

# Bind F11 and F12 (NOT F1 and F2) to previous and next screen window
bindkey -k F1 prev
bindkey -k F2 next
startup_message off

# Window list at the bottom.
hardstatus alwayslastline
hardstatus string "%-w%{= BW}%50>%n %t%{-}%+w%<"

The hardstatus creates a “task bar” listing all screens, with the active one highlighted. To understand switches, read this guide.