serenitii

MySQL Cheat Sheet

Reference for SQL commands

Login

mysql -u abc -h 13.209.48.208 -p

serenitii

Deploy Cheat Sheet

serenitii

#! /bin/bash

curl -sL https://deb.nodesource.com/setup_15.x -o nodesource_setup.sh

sudo sh nodesource_setup.sh

sudo apt install nodejs

node -v

serenitii

#!/bin/bash

# Ubuntu Server 2020.04

# 서버 시간 한국으로 설정
date
sudo ln -sf /usr/share/zoneinfo/Asia/Seoul /etc/localtime
date

# First add the required dependencies and the security key:

serenitii

#!/bin/bash

sudo docker container run -d --name mariadb mariadb -p 3306:3306 -e MYSQL_ROOT_PASSWORD="<YOUR_PASSWORD>"

sudo docker ps -a

serenitii

# Set user to root before execute this script
# sudo su
echo "whoami"
whoami
sleep 2s
cd /root

# Korean time
date
sudo ln -sf /usr/share/zoneinfo/Asia/Seoul /etc/localtime