docker run

docker run -itd --name mysql_python -v /home/ubuntu/docker/mysql/:/var/lib/mysql/ p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456 mysql


docker run -idt --name tornado_python -v /home/ubuntu/pythonproject/tornado/:/tornado/ -p 8000:8000 -p 8002:8002 -p 8003:8003 --link mysql_python:mysql_python python:3.6


docker run -idt --network host --name nginx_tornado -v /home/ubuntu/pythonproject/tornado/newssysytem_tornado/deploy/tornado_nginx.conf:/etc/nginx/conf.d/tornado_nginx.conf nginx

创建用户

CREATE USER 'zhangsan'@'%' IDENTIFIED BY zhangsan123';

授予所有权限

GRANT ALL PRIVILEGES ON *.* TO 'zhangsan'@'%' WITH GRANT OPTION;





# [RuntimeError: cryptography is required for sha256_password or caching_sha2_p](https://www.cnblogs.com/Hannibal-2018/p/11081143.html)

# 报错原因：mysql版本身份验证出现问题引起的

## 我这里报错的地方是在Django里，pycharm连接数据库时出现的

### **解决办法，安装安装cryptography即可:pip install cryptography 或者 pycharm里直接安装也可以**

pip install mysqlclient

sudo apt-get install python3 python-dev python3-dev build-essential libssl-dev libffi-dev libxml2-dev libxslt1-dev zlib1g-dev python-pip