Difference between revisions of "Command Snips"
From copec
(→MySQL) |
(→mysqlcheck) |
||
Line 28: | Line 28: | ||
=== mysqlcheck === | === mysqlcheck === | ||
<nowiki> | <nowiki> | ||
− | mysqlcheck --all-databases --repair | + | mysqlcheck --all-databases --repair |
− | + | ||
mysqlcheck --all-databases --optimize</nowiki> | mysqlcheck --all-databases --optimize</nowiki> | ||
Revision as of 12:23, 5 December 2017
Contents
Shell
Date String Stamp
`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...
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'; GRANT ALL PRIVILEGES ON new_db_name.* TO 'new_user'@'localhost'; FLUSH PRIVILEGES;
Update User Password
SET PASSWORD FOR 'username'@'%.example.com' = PASSWORD('good_password');
mysqlcheck
mysqlcheck --all-databases --repair mysqlcheck --all-databases --optimize
OpenSSL Testing
https://easyengine.io/tutorials/mail/server/testing/smtp/
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
systemd-resolve --flush-caches systemd-resolve --statistics