Command Snips

From copec
Revision as of 13:12, 27 October 2015 by Copec (Talk | contribs) (MySQL)

Jump to: navigation, search

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

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');