Skip to content

Instantly share code, notes, and snippets.

View jkullick's full-sized avatar

jkullick

View GitHub Profile
@jkullick
jkullick / nginx-config-basic.md
Last active August 4, 2016 12:34
Nginx Basic Configuration 
user www-data;
pid /var/run/nginx.pid;
worker_processes auto;
worker_rlimit_nofile 65536;

events {
  worker_connections 16384;
  multi_accept on;
 use epoll;
@jkullick
jkullick / nginx-config-ssl.md
Last active August 3, 2016 20:58
Nginx SSL Configuration 
server {
  listen 80;
  server_name _;
  
  return 301 https://$server_name$request_uri;
}

server {
 listen 443;
@jkullick
jkullick / ssl-generate-dhparam.md
Last active July 29, 2016 12:03
Generate SSL dhparam 
openssl dhparam -out /etc/ssl/certs/dhparam.pem 4096
@jkullick
jkullick / nginx-reverse-proxy-config.md
Last active July 29, 2016 10:54
Nginx Reverse Proxy Configuration 
upstream $PROXY_NAME {
  server 127.0.0.1:$PROXY_PORT;
}

server {
  location / {
    proxy_set_header  Host      $host;
    proxy_set_header  Proxy     "";
 proxy_set_header X-Real-IP $remote_addr;
@jkullick
jkullick / myql-create-database-user.md
Last active July 29, 2016 12:02
Create MySQL Database and User 
CREATE DATABASE $DATABASE CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE USER $USER@localhost IDENTIFIED BY '$PASSWORD';
GRANT ALL PRIVILEGES ON $DATABASE.* TO $USER;
FLUSH PRIVILEGES;
@jkullick
jkullick / mysql-basic-operations.md
Last active July 29, 2016 12:02
MySQL Basic Operations (Insert, Update, Delete) 
INSERT INTO `$TABLE` (`$FIELD_X`, `$FIELD_Y`, `$FIELD_Z`) VALUES ('$VALUE_X', '$VALUE_Y', '$VALUE_Z');
UPDATE `$TABLE` SET `$FIELD_X`='$VALUE_X', `$FIELD_Y`='$VALUE_Y', `$FIELD_Z`='$VALUE_Z' WHERE `$FIELD_ID`=$X;
DELETE FROM `$TABLE` WHERE `$FIELD_ID`=$X;
@jkullick
jkullick / mysql-change-charset-latin1-utf8.md
Last active December 29, 2016 13:34
Change MySQL Database Charset from Latin1 to UTF8

Method 1:

mysqldump -u$USER -p$PASSWORD -c -e --default-character-set=utf8 --single-transaction --skip-set-charset --add-drop-database -B $DATABASE | \
  sed -e 's/DEFAULT CHARACTER SET latin1/DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci/' -e 's/DEFAULT CHARSET=latin1/DEFAULT CHARSET=utf8/' | \
  mysql -u$USER -p$PASSOWRD

Method 2:

  1. Generate SQL statements
@jkullick
jkullick / mysql-backup-restore.md
Last active July 29, 2016 12:08
Backup & Restore MySQL Databases 
# Backup
mysqldump -u root -p --all-databases | gzip > dump.sql.gz

# Restore
gzip -d dump.sql.gz | mysql -u root -p
@jkullick
jkullick / mysql-replace-string-database.md
Last active July 29, 2016 12:07
Replace String in entire MySQL Database 
mysqldump -u$USER -p$PASSWORD $DATABASE | \
  sed -e 's/$OLD_STRING/$NEW_STRING/g' | \
  mysql -u$USER -p$PASSWORD $DATABASE
@jkullick
jkullick / mysql-change-allowed-hosts.md
Last active December 29, 2016 13:34
Change Allowed Hosts in MySQL 
UPDATE mysql.user SET host = '10.0.0.%' WHERE user != 'root';
UPDATE mysql.db SET host = '10.0.0.%' WHERE user != 'root';
FLUSH PRIVILEGES;

Source