Flask Web中用MySQL代替SQLite

 

<2>安装 libmysqlclient-dev

sudo apt-get install libmysqlclient-dev

 

<3>安装mysql-python

pip install mysql-python

 

2.安装完成后发现MySQLdb模块在虚拟环境中可成功导入，则说明安装成功，下面是使用mysql代替sqlite的方法：

<1>更改SQLALCHEMY_DATABASE_URI变量为：‘mysql://root:thinkive@127.0.0.1:3306/BlogTest‘

<2>在mysql中创建名为BlogTest的库

create database BlogTest default character set utf8 collate utf8_general_ci;

<img alt="技术分享" src="http://www.mamicode.com/data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAOQAAAFeCAIAAAAaEyR9AAAe90lEQVR4nO2dfXAT553H1etMMp3O/XNN25vptb3LTdqgJiUJ0JQXQ3CaZC4kgaZWEjItKek0pIEEQie8E9kYDFcwGZcjlTHlaq4HN0t7AyEvYGNIjG1eUwpUJBcgKCQYkyBQAMsyfnnuD8mr3X2eZ7Var3afffT9zA4jr/fZlfDPXz/a/exPAWKZ8vLynNuEw2FCkj996sH1f1jWT67MfOT2Xz38zUfH3dFD/vi 本文系统来源：http://www.cnblogs.com/qmfsun/p/6323697.html

【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:254677821)！