Cheat sheet for common web dev commands

cheat_sheet.md

Web dev cheat sheet

Things I don't remember offhand and have to look up. Now they're all in one place.

Command line

Make a file executable

chmod +x [file path]

Copy a file

cp [original file path] [new path]

Move a file

mv [original file path] [new path]

SSH

ssh [username]@[host IP or domain] -p [port]

MySQL

Dump a database

mysqldump -h [host IP] -P [port] -u [db user] -p[db pass] [db name] > [local file path].sql

Wordpress

Create user in Wordpress database

INSERT INTO `[db-name]`.`wp_users` (`ID`, `user_login`, `user_pass`, `user_nicename`, `user_email`, `user_status`, `display_name`) VALUES ('1000', 'tempuser', MD5('Str0ngPa55!'), 'tempuser', 'support@wpwhitesecurity.com', '0', 'Temp User');

Make user an admin

INSERT INTO `[db-name]`.`wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, '1000', 'wp_capabilities', 'a:1:{s:13:"administrator";b:1;}');

INSERT INTO `[db-name]`.`wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, '1000', 'wp_user_level', '10');

Git

Change remote URL

git remote set-url [remote name] [URL]

Undo a commit while keeping changes to files

git reset --soft HEAD [file path]