oiuyufeng
V2EX  ›  Flask

新手求教 python3 用 flask-sqlalchemy pymysql 连接 mysql

  •  
  •   oiuyufeng · May 29, 2016 · 5242 views
    This topic created in 3636 days ago, the information mentioned may be changed or developed.
    本地用树莓派直接 git checkout 源码,然后 google 把
    app.config['SQLALCHEMY_DATABASE_URI'] =\
    'sqlite:///' + os.path.join(basedir, 'data.sqlite')
    改成
    'mysql+pymysql://root:123@localhost/data_mysql' data_mysql 是已创建的一个数据库

    另外 /etc/mysql/my.cnf 里[client]最上面添加了三行方便登陆,现在是
    host = localhost
    user = root
    password = 123
    port = 3306
    socket = /var/run/mysqld/mysqld.sock

    运行之后提交表单显示 internal server error
    py hello.py shell 之后 create_all()报错 can't connect to mysql server on root,这个问题最多也是 on localhost 怎么报 on root?
    直接 https://github.com/PyMySQL/PyMySQL/blob/master/example.py 作者的例子, pymysql 连接 mysql 能正常输出 data_mysql 里的数据
    2 replies    2016-05-30 22:57:27 +08:00
    highway
        1
    highway  
       May 30, 2016   ❤️ 1
    最近在用 mysql.connector
    oiuyufeng
        2
    oiuyufeng  
    OP
       May 30, 2016 via Android
    @highway 这个也试过。。不知道为何也是 internal server error 。。
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Solana   ·   3615 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 66ms · UTC 10:38 · PVG 18:38 · LAX 03:38 · JFK 06:38
    ♥ Do have faith in what you're doing.