Django安裝筆記-指令列表
===
### 常用指令
* Apache reload
`sudo service apache2 reload`
* 進入虛擬環境
`source venv/bin/activate`
* 建立migration資料檔
`python manage.py makemigrations`
* 資料庫同步
`python manage.py migrate`
* 蒐集靜態文件
`python manage.py collectstatic --clear`
* Apache Error Log
`sudo tail -f /var/log/apache2/error.log`
* Web config folder
`sudo vim /etc/apache2/sites-available/`
* Docker執行指令
`docker exec -it `
### 虛擬環境
* 離開虛擬環境
`deactivate`
### Django2
* 執行django-q qcluster
`python manage.py qcluster`
* 產生語系檔

    python manage.py makemessages -l en
    python manage.py makemessages -l zh_Hant

* 編譯語系檔
`python manage.py compilemessages`
* 建立超級使用者
`python manage.py createsuperuser`
### Apache2
* 狀態
`sudo service apache2 status`
* Port conf
`sudo vim /etc/apache2/ports.conf`
* Config測試
`sudo apache2ctl configtest`
* 啟用配置檔
`sudo a2ensite`
* 停用配置檔
`sudo a2dissite`
* 清除Apache Error Log

    sudo service apache2 stop
    sudo bash -c 'echo > /var/log/apache2/error.log'
    sudo service apache2 start

### MySQL
* 登入
`mysql -u root -p`
* 顯示密碼規則
`show VARIABLES like "%password%";`
* 設定密碼規則

    set global validate_password_mixed_case_count = 0;
    set global validate_password_special_char_count = 0;

* 列出MySQL所有授權帳號
`select host,user from mysql.user;`
* 新增帳號

    grant all privileges on *.* to 帳號@'IP' identified by '密碼';
    flush privileges;//刷新授權表

* [忘記root密碼](http://www.okpc777.com/wp/archives/459)
* 修改database默認的字符集
`ALTER DATABASE database_name CHARACTER SET = utf8mb4 COLLATE =utf8mb4_unicode_ci;`
* 修改表默認的字符集和所有字符列的字符集
`ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;`
* 查看當前系統默認的字符集設置
`SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collation%';`
* 狀態
`systemctl status mysql.service`
* MySQL dump
1.匯出至sql檔
`mysqldump -h localhost -u <username> -p <database_name> > <file_name>.sql;`
2.匯出至sql檔，並輸出debug訊息至log檔
`mysqldump -v -u root -p <database_name> > <file_name>.sql 2> output.log`
### Docker
docker start <name>
docker exec -it <container_name> bash
docker cp <Container Name or ID>:<Container Source Path> <Host Destination Path> #將 Container 的資料匯出
docker cp <Host Source Path> <Container Name or ID>:<Container Destination Path> #將資料匯入到 Container
docker rmi $(docker images -f "dangling=true" -q)
docker-compose down
docker-compose up –d
docker-compose start
### 其他
* 檢查auth.log

    less /var/log/auth.log | grep Accepted
    less /var/log/auth.log | grep Failed

* 使用空間查詢
`du -sch * | sort -h`
* SSH通道查詢
`ps aux | grep ssh`
* 下載遠端檔案
`scp <username>@<ip>:<remote_path> <local_path>`
* 下載遠端檔案 指定port
`scp -P <port> <username>@<ip>:<remote_path> <local_path>`