#Database Cheat Sheet
For MySQL 5.5
- Change user password in MySQL
UPDATE mysql.user SET Password=PASSWORD('<new_password>') WHERE User='<user_name>'; FLUSH PRIVELAGES;
#Database Cheat Sheet
For MySQL 5.5
UPDATE mysql.user SET Password=PASSWORD('<new_password>') WHERE User='<user_name>';
FLUSH PRIVELAGES;
sshfs: | |
1. brew install sshfs | |
2. sudo /bin/cp -RfX /usr/local/opt/osxfuse/Library/Filesystems/osxfusefs.fs /Library/Filesystems | |
3. sudo chmod +s /Library/Filesystems/osxfusefs.fs/Support/load_osxfusefs | |
3. sshfs <username>@<hostname>:/path/to/directory <your directory> | |
macvim: | |
1. Download tar file | |
2. make install the file | |
3. mv /Users/<username>/Downloads/macvim-snapshot-73/src/MacVim/mvim ~/.rvm/bin |
sudo apt-get install python-software-properties
sudo add-apt-repository ppa:webupd8team/java
sudo apt-get update
sudo apt-get install oracle-java7-installer
Two global python packages are all that is really necessary:
sudo apt-get install python-pip
sudo pip install virtualenv
Start virtualenv (used Python3 in this case):
virtualenv <my env> --python=/usr/bin/python3
source <my env>/bin/activate
I hereby claim:
To claim this, I am signing this object:
CREATE USER 'root2'@'127.0.0.1' IDENTIFIED BY 'root'; | |
GRANT ALL PRIVILEGES ON *.* TO 'root2'@'127.0.0.1' WITH GRANT OPTION; | |
FLUSH PRIVILEGES; |