:q quit
:w write
:set number put numbers
i insert mode
esc command mode
dd command mode delete line
3dd delete 3 lines
u undo last action
ctrl r redo
/ search first match and enter
n next
N search backwards
i insert mode
:%s/text/textreplace/g g-for all c-with permission search and replace in command mode
CREATE USER 'cake'@'localhost' IDENTIFIED BY 'cake';
GRANT ALL PRIVILEGES ON * . * TO 'cake'@'localhost';
mysql -u username -p database_name < file.sql
Comments