Difference between revisions of "Command Snips"
From copec
Line 15: | Line 15: | ||
=== Update User Password === | === Update User Password === | ||
− | <nowiki> | + | <nowiki> |
− | SET PASSWORD FOR 'username'@'%.example.com' = PASSWORD('good_password'); | + | SET PASSWORD FOR 'username'@'%.example.com' = PASSWORD('good_password');</nowiki> |
− | + | ||
− | </nowiki> | + |
Revision as of 08:42, 9 June 2015
Contents
Shell
Date String Stamp
`date '+%Y-%m-%d-%Hh%M'`
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');