MYSQL连接FLask
时间: 2023-11-30 13:03:50 浏览: 25
要在 Flask 中连接 MySQL 数据库,需要使用一个名为 `Flask-MySQLdb` 的扩展。以下是连接 MySQL 数据库的基本步骤:
1. 安装 Flask-MySQLdb 扩展
```python
pip install flask-mysqldb
```
2. 在 Flask 应用程序中导入扩展
```python
from flask_mysqldb import MySQL
```
3. 配置 MySQL 连接参数
```python
app.config['MYSQL_HOST'] = 'localhost'
app.config['MYSQL_USER'] = 'username'
app.config['MYSQL_PASSWORD'] = 'password'
app.config['MYSQL_DB'] = 'database_name'
app.config['MYSQL_CURSORCLASS'] = 'DictCursor' # 可选项,用于返回字典类型数据
```
4. 初始化 MySQL 实例
```python
mysql = MySQL(app)
```
5. 使用 MySQL 实例进行查询操作
```python
cur = mysql.connection.cursor()
cur.execute("SELECT * FROM tablename")
results = cur.fetchall()
cur.close()
```
完整的 Flask-MySQLdb 连接 MySQL 数据库的示例代码如下:
```python
from flask import Flask
from flask_mysqldb import MySQL
app = Flask(__name__)
app.config['MYSQL_HOST'] = 'localhost'
app.config['MYSQL_USER'] = 'username'
app.config['MYSQL_PASSWORD'] = 'password'
app.config['MYSQL_DB'] = 'database_name'
app.config['MYSQL_CURSORCLASS'] = 'DictCursor'
mysql = MySQL(app)
@app.route('/')
def index():
cur = mysql.connection.cursor()
cur.execute("SELECT * FROM tablename")
results = cur.fetchall()
cur.close()
return str(results)
if __name__ == '__main__':
app.run()
```