这种情况原因众多,可能的一种错误原因是mysql数据库密码有特殊符合:@
from urllib import parse
from sqlalchemy import create_engine
mysqlEngine = create_engine("mysql+pymysql://root:yw%d#@$#lsy&@126.66.203.19:26306/mydata",pool_size=0, max_overflow=-1)
报错:
sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2003, "Can't connect to MySQL serve
正确写法:
from urllib import parse
from sqlalchemy import create_engine
user = "root"
password = "yw%d#@$#lsy&"
host = "126.66.203.19"
db = "mydata"
pwd = parse.quote_plus(password)
mysqlEngine = create_engine(f"mysql+pymysql://{user}:{pwd}@{host}:26306/{db}?charset=utf8",pool_size=0, max_overflow=-1)