Python: QSqlDatabase: QMYSQL driver not loaded

Question

I am running python 2.7.3 (python-2.7.3.amd64.msi) from http://www.python.org/getit/

I am using these installers from: http://www.lfd.uci.edu/~gohlke/pythonlibs/

PyQt-Py2.7-x64-gpl-4.9.6-1.exe
PySide-1.1.2.win-amd64-py2.7.exe
MySQL-python-1.2.4.win-amd64-py2.7.exe

I also tried the pyqt and pyside binaries from:

I am getting the error "QSqlDatabase: QMYSQL driver not loaded" in the following python code. My best guess is that the pyside and pyqt binary installers above did not build qt to include QMYSQL? Can anyone confirm that AND more importantly, direct me to an installer that has the QMYSQL driver built? I am not prepared to attempt compiling the qt library myself. Any help is appreciated.

import sys

from showrec import *    # import qtdesigner ui (converted using pyside-uic)

from PySide import QtGui, QtSql

#===================================================================
# 
#===================================================================

def createConnection():

    db = QtSql.QSqlDatabase.addDatabase('QMYSQL')

    db.setHostName('localhost')
    db.setDatabaseName('mydatabase')
    db.setUserName('userid')
    db.setPassword('password')
    db.open()
    print (db.lastError().text())
    return True

#===================================================================
#
#===================================================================

class MyForm(QtGui.QDialog):

    def __init__(self, parent=None):

        #super(MyForm, self).__init__(parent)   # I suspect this is needed?

        QtGui.QWidget.__init__(self,parent)
        self.ui = Ui_Dialog()
        self.ui.setupUi(self)

        self.model = QtSql.QSqlDatabase(self)
        self.model.setTable("products")
        self.model.setEditStrategy(QtSql.QSqlTableModel.OnManualSubmit)
        self.model.select()
        self.ui.tableView.setModel(self.model)

#===================================================================
# main
#===================================================================

if __name__ == "__main__":

    app = QtGui.QApplication(sys.argv)

    if not createConnection():
        sys.exit(1)

    myapp = MyForm()
    myapp.show()

    sys.exit(app.exec_())

This the the gui code:

from PySide import QtCore, QtGui

class Ui_Dialog(object):
    def setupUi(self, Dialog):
        Dialog.setObjectName("Dialog")
        Dialog.resize(400, 300)
        self.tableView = QtGui.QTableView(Dialog)
        self.tableView.setGeometry(QtCore.QRect(20, 20, 256, 192))
        self.tableView.setObjectName("tableView")

        self.retranslateUi(Dialog)
        QtCore.QMetaObject.connectSlotsByName(Dialog)

    def retranslateUi(self, Dialog):
        Dialog.setWindowTitle(QtGui.QApplication.translate("Dialog", "Dialog", None, QtGui.QApplication.UnicodeUTF8))

please check if you can find `qsqlmysql4.dll` in this path `C:\Python26\Lib\site-packages\PyQt4\plugins\sqldrivers`(if you are using windows). if you can find the dll, the installation is correct. — Sudeepth Patinjarayil, Apr 15 '13 at 07:21
for modern PySide6 the solution in described at https://stackoverflow.com/a/72169911 — Nishi, Jan 21 '23 at 22:38

score 1 · Answer 1 · answered Apr 11 '13 at 08:52

1

regarding to PySide, the official 64bit windows installer (downloaded from PySide home page) does support only QSQLITE driver. The 32bit installer support QSQLITE QODBC3 QODBC QPSQL7 QPSQL drivers. R.

answered Apr 11 '13 at 08:52

rlacko

571
3
11

Thanks! I just decided to use pyqt4 instead of pyside, because the installer has the QMYSQL driver. – panofish Apr 25 '13 at 14:03
I will try to prepare the new PySide release with QMYSQL (and other) driver. I will inform you when it is ready. Regards. R. – rlacko Apr 25 '13 at 19:08
@rlacko is there a link to where this was discussed? – eric Nov 15 '14 at 01:23

score 0 · Accepted Answer · answered May 03 '13 at 15:11

0

I decided to use pyqt4 instead of pyside, because the installer contains the QMYSQL driver.

answered May 03 '13 at 15:11

panofish

7,578
13
55
96

Python: QSqlDatabase: QMYSQL driver not loaded

2 Answers2