UnicodeDecodeError ascii codec can t decode byte 0xba in position 1 ordinal not in range 128 in python

Question

我使用的是python2.7.15，当运行下面的代码时，我得到了unicode错误 请帮我修一下

我试过了sys.setdefaultencoding系统（“utf-8”）它仍然不起作用。你知道吗

from flask import Flask
from flask_sqlalchemy import SQLAlchemy


app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql://root:$%ba5ca8ea@127.0.0.1:3388/login'
db = SQLAlchemy(app)

class fpuser3(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    public_id = db.Column(db.String(50), unique=True)
    name = db.Column(db.String(50))
    password = db.Column(db.String(80))
    admin = db.Column(db.Boolean)

db.create_all()

print "Tables Created"

我希望在本地数据库中创建表。你知道吗

下面是我得到的错误

C:\Python27\lib\site-packages\flask_sqlalchemy\__init__.py:835: FSADeprecationWa
rning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disa
bled by default in the future.  Set it to True or False to suppress this warning
.
  'SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and '
Traceback (most recent call last):
  File "C:\inetpub\wwwroot\securitytool\createDB.py", line 17, in <module>
    db.create_all()
  File "C:\Python27\lib\site-packages\flask_sqlalchemy\__init__.py", line 1033,
in create_all
    self._execute_for_all_tables(app, bind, 'create_all')
  File "C:\Python27\lib\site-packages\flask_sqlalchemy\__init__.py", line 1025,
in _execute_for_all_tables
    op(bind=self.get_engine(app, bind), **extra)
  File "C:\Python27\lib\site-packages\flask_sqlalchemy\__init__.py", line 956, i
n get_engine
    return connector.get_engine()
  File "C:\Python27\lib\site-packages\flask_sqlalchemy\__init__.py", line 561, i
n get_engine
    self._engine = rv = self._sa.create_engine(sa_url, options)
  File "C:\Python27\lib\site-packages\flask_sqlalchemy\__init__.py", line 966, i
n create_engine
    return sqlalchemy.create_engine(sa_url, **engine_opts)
  File "C:\Python27\lib\site-packages\sqlalchemy\engine\__init__.py", line 435,
in create_engine
    return strategy.create(*args, **kwargs)
  File "C:\Python27\lib\site-packages\sqlalchemy\engine\strategies.py", line 98,
in create
    (cargs, cparams) = dialect.create_connect_args(u)
  File "C:\Python27\lib\site-packages\sqlalchemy\dialects\mysql\mysqldb.py", lin
e 168, in create_connect_args
    database="db", username="user", password="passwd"
  File "C:\Python27\lib\site-packages\sqlalchemy\engine\url.py", line 216, in tr
anslate_connect_args
    if name is not None and getattr(self, sname, False):
  File "C:\Python27\lib\site-packages\sqlalchemy\engine\url.py", line 134, in pa
ssword
    return util.text_type(self.password_original)
UnicodeDecodeError: 'ascii' codec can't decode byte 0xba in position 1: ordinal
not in range(128)