找回密码
 立即注册

扫一扫,访问微社区

QQ登录

只需一步,快速开始

查看: 5221|回复: 0

[求助] 关于python的pymysql模块在服务器端(CPanel)的数据库连接失败

1

主题

1

帖子

1

积分

贫民

积分
1
shyo 发表于 2017-4-12 18:22:02 | 显示全部楼层 |阅读模式
1威望
源码如下
  1. from flask import Flask
  2. from flask_bootstrap import Bootstrap


  3. import pymysql
  4. import os


  5. app = Flask(__name__)
  6. bootstrap = Bootstrap(app)
  7. app.config.from_object('config')
  8. #db = SQLAlchemy(app)
  9. conn = pymysql.connect(host='ip_address',port=3306,user='username',passwd='password',db='db_name',charset='utf8')

  10. cur = conn.cursor()
  11. basedir = os.path.abspath(os.path.dirname(__file__))

  12. from app import views
复制代码
报错是在conn = pymysql.connect这一语句。
这个程序在本地是可以链接到服务器端的数据库的,但是在服务器端就不行,也试过了unix_socket这个参数也失败了。
错误信息如下:
  1. [ 2017-04-12 18:15:24.7224 513785/7f3bec072700 age/Cor/App/Implementation.cpp:304 ]: Could not spawn process for application /home/.../flask: An error occurred while starting the web application. It exited before signalling successful startup back to Phusion Passenger.
  2. App 519523 stderr:   File "/home/.../virtualenv/flask/3.5/lib/python3.5/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
  3. App 519523 stderr:   File "/home/.../virtualenv/flask/3.5/lib/python3.5/site-packages/pymysql/connections.py", line 393, in check_error
  4. App 519523 stderr:   File "/home/.../virtualenv/flask/3.5/lib/python3.5/site-packages/pymysql/connections.py", line 1014, in _read_packet
  5. App 519523 stderr:   File "/home/.../virtualenv/flask/3.5/lib/python3.5/site-packages/pymysql/connections.py", line 1152, in _request_authentication
  6. App 519523 stderr:   File "/home/.../virtualenv/flask/3.5/lib/python3.5/site-packages/pymysql/connections.py", line 932, in connect
  7. App 519523 stderr:   File "/home/.../virtualenv/flask/3.5/lib/python3.5/site-packages/pymysql/connections.py", line 706, in __init__
  8. App 519523 stderr:   File "/home/.../virtualenv/flask/3.5/lib/python3.5/site-packages/pymysql/__init__.py", line 90, in Connect
  9. App 519523 stderr:   File "/home/.../flask/app/__init__.py", line 13, in <module>
  10. App 519523 stderr:   File "/home/.../flask/run.py", line 1, in <module>
  11. App 519523 stderr:   File "/home/.../flask/passenger_wsgi.py", line 16, in <module>
  12. App 519523 stderr:   File "/home/.../virtualenv/flask/3.5/lib64/python3.5/imp.py", line 172, in load_source
复制代码
服务器端是虚拟主机,用的是CPanel面板

回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

快速回复 返回顶部 返回列表