mycharm+anaconda+mysql

1.mycharm+anaconda环境 见Tensorflow安装

2.安装pymysql+mysql-connector-python
pip install pymysql
pip install mysql-connector-python
安装后查看interpreter下conda编译器有相关选项
3.链接数据库
from sqlalchemy import create_engine
engine = create_engine(‘mysql+pymysql://root:root@localhost:3306/test?charset=utf8’)
root:root为用户名，test为数据库
4.数据库日志查看
mysql> show variables like ‘%log%’;查看mysql各日志地址
主要的如：
general_log_file
log_error