server

FrontPage

ubuntu 16.04 †

letsencrypt †

install †

sudo apt-get install letsencrypt

docker †

install †

docker本体 †

https://docs.docker.com/install/linux/docker-ce/ubuntu/

sudo apt-get remove docker docker-engine docker.io containerd runc
sudo apt-get update
sudo apt-get install \
   apt-transport-https \
   ca-certificates \
   curl \
   gnupg-agent \
   software-properties-common
curl -fsSL https://download.docker.com/linux/ubuntu/gpg | sudo apt-key add -
sudo apt-key fingerprint 0EBFCD88
sudo add-apt-repository \
  "deb [arch=amd64] https://download.docker.com/linux/ubuntu \
  $(lsb_release -cs) \
  stable"
sudo apt-get update
sudo apt-get install docker-ce docker-ce-cli containerd.io

dockerをユーザーから使えるようにする

sudo gpasswd ichinomoto -a docker

docker-compose †

https://docs.docker.com/compose/install/

sudo curl -L "https://github.com/docker/compose/releases/download/1.24.0/docker-compose-$(uname -s)-$(uname -m)" -o /usr/local/bin/docker-compose
sudo chmod +x /usr/local/bin/docker-compose
sudo ln -s /usr/local/bin/docker-compose /usr/bin/docker-compose

mariadb(mysql)移行 †

完全初期化 †

sudo rm -fr /var/lib/musql/*
su - mysql 
mysql_install_db --datadir=/var/lib/mysql

backup †

mysqldump --all-databases > dump.sql

restore †

mysql < dump.sql

user追加など †

操作するdbをmysqlに変更

USE mysql;

user一覧

SELECT user,host FROM mysql.user;

user作成

CREATE USER 'ユーザー名'@'ホスト名' IDENTIFIED BY 'パスワード';

usernameに全権限付与

GRANT ALL PRIVILEGES ON *.* TO 'ユーザー名'@'ホスト名' IDENTIFIED BY 'パスワード' WITH GRANT OPTION;
FLUSH PRIVILEGES;