Basic SQL stuff that I always forget and have to google.

mysql-commands.bash

# Access Mysql 
mysql -u mysql_username -p
# ie: mysql -u root -p

# Show db uns/pws (on DO)
cat /root/.digitalocean_password

# Dump db to root on server to current location (gen root after ssh)
mysqldump -u [username] -p [target_database_name] > [exported_database_file_name].sql

# Import to db
mysqldump -u root -p target_databasename < database_or_table_to_import.sql

# Change U P
update user set password=PASSWORD("your_password") where User='some_user_name';

# Create DB
CREATE DATABASE new_database_name;

# Add new table column, DATETIME, defaulting to current timestamp
ALTER TABLE my_table_name ADD new_table_column_name DATETIME DEFAULT CURRENT_TIMESTAMP;

# Commons
SHOW DATABASES;
USE DATABASE_NAME;
SHOW TABLES;