Import Error in flask importing MYSQL in python in vs code?

Question

from flask import Flask, render_template,redirect, 
session,url_for,request
from flask_mysqldb  import MYSQl
app = Flask(__name__)
app.secret_key="12345678"

app.config["MYSQL_HOST"] = "localhost"
app.config["MYSQL_USER"]="root"
app.config["MYSQL_PASSWORD"]="123457"
app.config["MYSQL_DB"] = "management"
db = MYSQL(app)

This is the library code in vs code that do not show error here

I installed mysql. but when i run in python it giving error how do i remove import error for flask_mysqldb.In second snap showing import error while library already installed.In third snap, This is the snap of flask mysqldb is installed

Please add code and data as text (using code formatting), not images. Images: A) don't allow us to copy-&-paste the code/errors/data for testing; B) don't permit searching based on the code/error/data contents; and many more reasons. Images should only be used, in addition to text in code format, if having the image adds something significant that is not conveyed by just the text code/error/data. — snakecharmerb
– snakecharmerb, Commented Sep 19, 2021 at 13:39
because i am working on this library. i use this for accessing MySQL data — Muhammad Irfan Shahzad
– Muhammad Irfan Shahzad, Commented Sep 19, 2021 at 13:47

Muhammad Irfan Shahzad · Accepted Answer · 2021-09-19 13:55:23Z

1

For import MySQL in flask. The Syntax are from flask_mysqldb import MySQL. 'y' always in lowercase in " MySQL"

answered Sep 19, 2021 at 13:55

Muhammad Irfan Shahzad

1151 gold badge2 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

davidism · Accepted Answer · 2021-09-19 13:46:13Z

0

**Did you install flask-mysql? **

If you haven't, Install it by running the following command in command prompt.

pip install flask-mysql

If you've already installed flask-mysql, as I can see from the screenshots of the error your import statement is incorrect,

Import it as:

from flask_mysql import MySQL

edited Sep 19, 2021 at 13:46

davidism

128k31 gold badges417 silver badges348 bronze badges

answered Sep 19, 2021 at 13:36

Ashish Papanai

8810 bronze badges

4 Comments

Muhammad Irfan Shahzad Over a year ago

This line giving same error on flaskext .mysql

AKX Over a year ago

Probably MySQL, not MYSQL.

Muhammad Irfan Shahzad Over a year ago

but still giving error by MySQL

Muhammad Irfan Shahzad Over a year ago

I replace MYSQL with MySQL. In my previous library it will solved.

Collectives™ on Stack Overflow

Import Error in flask importing MYSQL in python in vs code?

2 Answers 2

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related