# Can‘t connect to MySQL server on ‘lnz‘ ([Errno 11001] getaddrinfo failed)

执行操作

from test_platform.tools.login_api import db
db.create_all()

代码

from flask import Flask
from flask_restful import Resource, Api
from flask_sqlalchemy import SQLAlchemy
from flask_jwt_extended import JWTManager, create_access_token, jwt_required
app = Flask(__name__)
api = Api(app)
app.config[
    'SQLALCHEMY_DATABASE_URI'] = 'mysql+pymysql://lnz:123456/platform_python'
db = SQLAlchemy(app)
app.config['JWT_SECRET_KEY'] = 'ceshiren'  # Change this!
jwt = JWTManager(app)

class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(80), unique=True, nullable=False)
    email = db.Column(db.String(120), unique=True, nullable=False)

    def __repr__(self):
        return '<User %r>' % self.username

sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2003, "Can't connect to MySQL server on 'lnz' ([Errno 11001] getaddrinfo failed)")
(Background on this error at: http://sqlalche.me/e/13/e3q8)

解决方案

修改这行代码为如下

app.config[
    'SQLALCHEMY_DATABASE_URI'] = 'mysql+pymysql://lnz:123456@127.0.0.1:3306/platform_python'