I did not manage to solve this error that appears to me when trying to connect to a Mysql database with PyQt5
Instruction used:
from PyQt5.QtSql import QSqlDatabase, QSqlQuery, QSqlTableModel
from PyQt5.QtWidgets import QTableView, QApplication
import sys
def dbcon():
db = QSqlDatabase.addDatabase('QMYSQL')
db.setHostName('localhost')
db.setDatabaseName('db_librowad')
db.setUserName('root')
db.setPassword('12345')
ok = db.open()
if not ok: print(db.lastError().text())
# else: print("connected")
query = QSqlQuery(db)
query.exec_('SELECT * FROM tbl_Customers')
if __name__ == '__main__':
app = QApplication(sys.argv)
dbcon()
Error Message
QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QODBC QODBC3 QPSQL QPSQL7
Driver not loaded Driver not loaded
QSqlQuery::exec: database not open
Presione una tecla para continuar . . .