Difference between revisions of "Command Snips"
From copec
(→Create New Database and User) |
|||
| (3 intermediate revisions by the same user not shown) | |||
| Line 5: | Line 5: | ||
echo 1 > /proc/sys/kernel/sysrq | echo 1 > /proc/sys/kernel/sysrq | ||
echo b > /proc/sysrq-trigger | echo b > /proc/sysrq-trigger | ||
| + | |||
| + | === tcpdump ipv6 === | ||
| + | tcpdump -i <interface name> -n -vv '(udp port 546 or 547) or icmp6' | ||
=== Date String Stamp === | === Date String Stamp === | ||
| Line 29: | Line 32: | ||
CREATE USER 'new_user'@'%' IDENTIFIED BY 'good_password'; | CREATE USER 'new_user'@'%' IDENTIFIED BY 'good_password'; | ||
GRANT ALL PRIVILEGES ON new_db_name.* TO 'new_user'@'localhost'; | GRANT ALL PRIVILEGES ON new_db_name.* TO 'new_user'@'localhost'; | ||
| + | GRANT ALL PRIVILEGES ON *.* TO 'root'@' WITH GRANT OPTION; | ||
GRANT ALL PRIVILEGES ON new_db_name.* TO 'new_user'@'%'; | GRANT ALL PRIVILEGES ON new_db_name.* TO 'new_user'@'%'; | ||
FLUSH PRIVILEGES;</nowiki> | FLUSH PRIVILEGES;</nowiki> | ||
| Line 49: | Line 53: | ||
PURGE BINARY LOGS BEFORE now(); | PURGE BINARY LOGS BEFORE now(); | ||
*Disable logging: /etc/mysql/conf.d/mysql_skip_log_bin.cnf: | *Disable logging: /etc/mysql/conf.d/mysql_skip_log_bin.cnf: | ||
| − | <nowiki> | + | <nowiki> |
[mysqld] | [mysqld] | ||
| − | skip_log_bin | + | skip_log_bin</nowiki> |
| − | </nowiki> | + | |
== OpenSSL Testing == | == OpenSSL Testing == | ||
Latest revision as of 14:40, 22 March 2024
For infrequent things I tend not to remember off the top of my head.
Contents
Shell
Linux Kernel CPU Reset
echo 1 > /proc/sys/kernel/sysrq echo b > /proc/sysrq-trigger
tcpdump ipv6
tcpdump -i <interface name> -n -vv '(udp port 546 or 547) or icmp6'
Date String Stamp
`date '+%Y-%m-%d-%Hh%M'`
- For Example:
mysqldump ... > bleh.`date '+%Y-%m-%d-%Hh%M'`.sql zfs snapshot -r tank@copec-snap_`date '+%Y-%m-%d-%Hh%M'`
Lock gnome >3.8 remote
DISPLAY=:0 dbus-send --type=method_call --dest=org.gnome.ScreenSaver /org/gnome/ScreenSaver org.gnome.ScreenSaver.Lock
Re-Mount / RW (I always forget the exact syntax...)
- Might want to add standard mount options to the "-o" like "discard" or "noatime"
mount -o remount,rw /
MySQL
Create New Database and User
For database 'new_db_name' and user 'new_user':
mysql --defaults-file=/etc/mysql/debian.cnf CREATE DATABASE new_db_name; CREATE USER 'new_user'@'localhost' IDENTIFIED BY 'good_password'; CREATE USER 'new_user'@'%' IDENTIFIED BY 'good_password'; GRANT ALL PRIVILEGES ON new_db_name.* TO 'new_user'@'localhost'; GRANT ALL PRIVILEGES ON *.* TO 'root'@' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON new_db_name.* TO 'new_user'@'%'; FLUSH PRIVILEGES;
Update User Password
SET PASSWORD FOR 'username'@'%.example.com' = PASSWORD('good_password');
Mysqlchecks
mysqlcheck --all-databases --repair mysqlcheck --all-databases --optimize
Dumps
- For human consumption:
mysqldump --defaults-file=/etc/mysql/debian.cnf --skip-opt <databasename>
Binary Logs
- Purge all logs:
PURGE BINARY LOGS BEFORE now();
- Disable logging: /etc/mysql/conf.d/mysql_skip_log_bin.cnf:
[mysqld] skip_log_bin
OpenSSL Testing
RAID
mdadm --create --verbose /dev/md0 --level=1 --raid-devices=2 /dev/sda2 /dev/sdb2 mdadm --detail --scan >> /etc/mdadm/mdadm.conf
Mirror Website
wget --mirror --convert-links --adjust-extension --page-requisites --no-parent http://example.org
Systemd
- Flush DNS cache using the systemd stub resolver:
systemd-resolve --flush-caches systemd-resolve --statistics
MacOS
Linux kexec reboot
alias kreboot="echo Loading kexec; kexec -l /vmlinuz --initrd=/initrd.img --reuse-cmdline; echo Rebooting; kexec -e"
