如標題所述,也有查網路上SQLALCHEMY URI欄位 mysql規則的寫法,
在Connect a database視窗,SQLALCHEMY URI* 欄位輸入以下8種寫法都試過...
{}只是說明我打的內容,實際上打的時候,沒有加{}
該安裝的mysqlclient和sqlalchemy都有安裝...
1.mysql://{username}:{password}@127.0.0.1:3306/{mysqldatabasename}
2.mysql://{username}:{password}@localhost:3306/{mysqldatabasename}
3.mysql+pymysql://{username}:{password}@127.0.0.1:3306/{mysqldatabasename}
4.mysql+pymysql://{username}:{password}@localhost:3306/{mysqldatabasename}
5.mysql+pymysql://{username}:{password}@{127.0.0.1}:3306/{mysqldatabasename}
6.mysql+pymysql://{username}:{password}@localhost:3306/{mysqldatabasename}
7.mysql+mysqlconnector://{username}:{password}@{127.0.0.1}/{mysqldatabasename}
8.mysql+mysqlconnector://{username}:{password}@{localhost}/{mysqldatabasename}
但還是無法連上...一直出現這個error msg:"ERROR: Could not load database driver: MySQLEngineSpec"
希望能有大師幫忙解答,謝謝
=====
因為新手期間無法回覆也無法選為最佳解答,我只能回覆在貼文上喔:
1.上面1,3,7的寫法,就是已經用127.0.0.1
2.再重下指令安裝pymysql,有成功喔!@force謝謝您