1046错误mysql_MySQLdb_异常操作错误('1046,未选择数据库)烧瓶到mySQL连接

我花了那么多时间想弄清楚,我迷路了。在

我正在尝试做一个小的网络应用程序,看一些教程。。。在I keep getting this error: MySQLdb._exceptions.OperationalError ('1046, No database selected')

这是我的代码:# app.py

from flask import Flask, render_template, flash, redirect, url_for, session, logging, request

# from flask_sqlalchemy import SQLAlchemy

# from data import Articles

from data import Articles

from flask_mysqldb import MySQL

from wtforms import Form, StringField, TextAreaField, PasswordField, validators

from passlib.hash import sha256_crypt

app = Flask(__name__)

# app.config['SECRET_KEY'] = 'xxxxxxxxxx'

# Config MySQL

app.config['MySQL_HOST'] = 'localhost'

app.config['MySQL_USER'] = 'root'

app.config['MySQL_PASSWORD'] = ''

app.config['MySQL_DB'] = 'myflaskapp'

app.config['MySQL_CURSORCLASS'] = 'DictCursor'

# Init MySQL

mysql = MySQL(app)

# Setting articles

Articles = Articles()

@app.route('/')

def home():

return render_template('home.html')

@app.route('/about')

def about():

return render_template('about.html')

@app.route('/articles')

def articles():

return render_template('articles.html', articles=Articles)

@app.route('/article//')

def article(id):

return render_template('article.html', id=id)

class RegisterForm(Form):

name = StringField('Name', [validators.Length(min=1, max=50)])

username = StringField('Username', [validators.Length(min=4, max=25)])

email = StringField('Email', [validators.Length(min=6, max=50)])

password = PasswordField('Password', [validators.DataRequired(),

validators.EqualTo(

'confirm', message='Passwords do not match!')

])

confirm = PasswordField('Confirm Password')

@app.route('/register', methods=['GET', 'POST'])

def register():

form = RegisterForm(request.form)

if request.method == 'POST' and form.validate():

name = form.name.data

email = form.email.data

username = form.username.data

password = sha256_crypt.encrypt(str(form.password.data))

# Creat Cursor

cur = mysql.connection.cursor()

# Execute Query

cur.execute("INSERT INTO users(name, email, username, password) VALUES(%s, %s, %s, %s)",

(name, email, username, password))

# Commit to DB

mysql.connection.commit()

# close connection

cur.close()

# Message to user once registered

flash('You are now registered and can login, thank you', 'success')

return redirect(url_for('index'))

return render_template('register.html', form=form)

if __name__ == '__main__':

app.run(debug=True)

如果我评论MYSQL的配置,我没有得到一个密码拒绝错误,所以我很困惑,我是不是在MYSQL安装过程中搞砸了?在

此外,我使用show database检查了我的DB exists;我访问了myflaskapp中的user表,并在phpmyadmin上进行了检查。在

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值