from flask import Flask, request
import torch
import mlflow
import torchaudio
#from flaskext.mysql import MySQL
from flask_mysqldb import MySQL
import configMy
import numpy as np
import os
import moviepy.editor as mp
import matplotlib.pyplot as plt
from pathlib import Path
from tempfile import TemporaryDirectory
app = Flask(__name__)
#mysql = MySQL()
mysql = MySQL(app)
# MySQL配置
app.config['MYSQL_DATABASE_USER'] = configMy.MYSQL_DATABASE_USER
app.config['MYSQL_DATABASE_PASSWORD'] = configMy.MYSQL_DATABASE_PASSWORD
app.config['MYSQL_DATABASE_DB'] = configMy.MYSQL_DATABASE_DB
app.config['MYSQL_DATABASE_HOST'] = configMy.MYSQL_DATABASE_HOST
mysql.init_app(app)
@app.route('/testSelect')
def indexSelect():
# 获取数据库连接
conn = mysql.connect(user='root', password='****', host='localhost', database='&&&&')
#conn = mysql.connect()
cursor = conn.cursor()
# 执行查询
cursor.execute("SELECT count(*) FROM user_info")
# 获取查询结果
data = cursor.fetchall()
# 关闭连接
cursor.close()
conn.close()
return str(data)
报错:MySQLdb.OperationalError: (1045, "Access denied for user 'Administrator'@'localhost' (using password: NO)"),为什么是 Administrator呢?我的用户名明明是root
还是java爽啊,随便就连上了,python鼓捣好久,连不上。我上次就是因为python连不上数据库,从而转投java的。这次没办法了,必须得连上。有大佬指教一下吗?谢谢
--
FROM 120.242.238.*