Ubuntu Pyqt QMYSQL driver available but not loaded

install this: `sudo apt-get install libmysqlclient-dev libqt5sql5-mysql` – eyllanesc Jun 07 '17 at 01:19

Possible duplicate of [QMYSQL driver available but not loaded](https://stackoverflow.com/questions/14667768/qmysql-driver-available-but-not-loaded) – eyllanesc Jun 07 '17 at 01:27

@eyllanescl I installed libmysqlclient-dev libqt5sql5-mysql not possible. – 고요한 Jun 07 '17 at 01:47

Find the appropriate package name with: `sudo apt-cache search libmysqlclient` and `sudo apt-cache search libqt5sql5` – eyllanesc Jun 07 '17 at 01:48

@eylianesc libmysqlclient-dev - MySQL database development files libmysqlclient20 - MySQL database client library libcrypt-mysql-perl - Perl module to emulate the MySQL PASSWORD() function libglpk36 - linear programming kit with integer (MIP) support – 고요한 Jun 07 '17 at 01:49

execute: `sudo apt-get install libmysqlclient-dev` – eyllanesc Jun 07 '17 at 01:50

@eyllanesc libmysqlclient-dev Installed – 고요한 Jun 07 '17 at 01:51

execute this: `sudo apt-cache search libqt5sql5` – eyllanesc Jun 07 '17 at 01:52

@eyllabesc libqt5sql5 - Qt 5 SQL module libqt5sql5-sqlite - Qt 5 SQLite 3 database driver libqt5sql5-mysql - Qt 5 MySQL database driver libqt5sql5-odbc - Qt 5 ODBC database driver libqt5sql5-psql - Qt 5 PostgreSQL database driver libqt5sql5-tds - Qt 5 FreeTDS database driver – 고요한 Jun 07 '17 at 01:52

execute: `sudo apt-get install libqt5sql5-sqlite libqt5sql5-mysql libqt5sql5-odbc libqt5sql5-psql libqt5sql5-tds libqt5sql5` – eyllanesc Jun 07 '17 at 01:54

Install all the packages that come out on that list. – eyllanesc Jun 07 '17 at 01:56

Installed pycharm QSqlDatabase: QMYSQL driver not loaded – 고요한 Jun 07 '17 at 01:57

Find the `libqsqlmysql.so` file and run: `ldd libqsqlmysql.so` – eyllanesc Jun 07 '17 at 01:59

@eyllanesc libmysqlclient.so.18 => not found – 고요한 Jun 07 '17 at 02:00

An easy way to find it is to run: `sudo locate libqsqlmysql.so` – eyllanesc Jun 07 '17 at 02:00

ldd libqsqlmysql.so libmysqlclient.so.18 => not found – 고요한 Jun 07 '17 at 02:00

@eyllanesc /home/pos/Development/DB_Change/libqsqlmysql.so /usr/lib/x86_64-linux-gnu/qt4/plugins/sqldrivers/libqsqlmysql.so /usr/lib/x86_64-linux-gnu/qt5/plugins/sqldrivers/libqsqlmysql.so /usr/local/lib/python3.5/dist-packages/PyQt5/libqsqlmysql.so /usr/local/lib/python3.5/dist-packages/PyQt5/Qt/plugins/sqldrivers/libqsqlmysql.so /usr/local/lib/python3.5/dist-packages/PyQt5/sqldrivers/libqsqlmysql.so – 고요한 Jun 07 '17 at 02:01

execute: `ldd /usr/local/lib/python3.5/dist-packages/PyQt5/sqldrivers/libq‌sqlmysql.so` – eyllanesc Jun 07 '17 at 02:02

@eyllanesc There is no such file. – 고요한 Jun 07 '17 at 02:03

execute: `sudo updatedb && sudo locate libqsqlmysql.so` – eyllanesc Jun 07 '17 at 02:04

/home/pos/Development/DB_Change/libqsqlmysql.so /usr/lib/x86_64-linux-gnu/qt4/plugins/sqldrivers/libqsqlmysql.so /usr/lib/x86_64-linux-gnu/qt5/plugins/sqldrivers/libqsqlmysql.so /usr/local/lib/python3.5/dist-packages/PyQt5/libqsqlmysql.so /usr/local/lib/python3.5/dist-packages/PyQt5/Qt/plugins/sqldrivers/libqsqlmysql.so /usr/local/lib/python3.5/dist-packages/PyQt5/sqldrivers/libqsqlmysql.so – 고요한 Jun 07 '17 at 02:06

execute: `ldd /usr/lib/x86_64-linux-gnu/qt5/plugins/sqldrivers/libqsqlmysq‌l.so` – eyllanesc Jun 07 '17 at 02:07

And also try to reinstall pyqt5. – eyllanesc Jun 07 '17 at 02:07

There is no such file. – 고요한 Jun 07 '17 at 02:08

I find it strange, try restarting your pc. – eyllanesc Jun 07 '17 at 02:09

libqsqlmysq‌‌l.so no surch – 고요한 Jun 07 '17 at 02:09

execute this: `sudo apt-get install libqt5sql5` – eyllanesc Jun 07 '17 at 02:10

@eyllanesc libqt5sql5 Installed – 고요한 Jun 07 '17 at 02:18

execute: `locate libqsqlmysql.so` – eyllanesc Jun 07 '17 at 02:19

/home/pos/Development/DB_Change/libqsqlmysql.so /usr/lib/x86_64-linux-gnu/qt4/plugins/sqldrivers/libqsqlmysql.so /usr/lib/x86_64-linux-gnu/qt5/plugins/sqldrivers/libqsqlmysql.so /usr/local/lib/python3.5/dist-packages/PyQt5/libqsqlmysql.so /usr/local/lib/python3.5/dist-packages/PyQt5/Qt/plugins/sqldrivers/libqsqlmysql.so /usr/local/lib/python3.5/dist-packages/PyQt5/sqldrivers/libqsqlmysql.so – 고요한 Jun 07 '17 at 02:21

@eyllanesc Computer Restart is Pyqt Reinstall – 고요한 Jun 07 '17 at 02:22

QSqlDatabase: QMYSQL driver not loaded – 고요한 Jun 07 '17 at 02:22

execute: `cd /usr/lib/x86_64-linux-gnu/qt5/plugins/sqldrivers/` and then run: `ldd libqsqlmysql.‌so` – eyllanesc Jun 07 '17 at 02:22

execute: `sudo apt-get update && sudo apt-get install qt5-default` – eyllanesc Jun 07 '17 at 02:24

linux-vdso.so.1 => (0x00007fff69bee000) libmysqlclient.so.20 => /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20 (0x00007f218151f000) libQt5Sql.so.5 => /usr/lib/x86_64-linux-gnu/libQt5Sql.so.5 (0x00007f21814dd000) libQt5Core.so.5 => /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 (0x00007f2181006000) libstdc++.so.6 => /usr/lib/x86_64-linux-gnu/libstdc++.so.6 (0x00007f2180c84000) libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007f21808bb000) – 고요한 Jun 07 '17 at 02:25

libstdc++.so.6 => /usr/lib/x86_64-linux-gnu/libstdc++.so.6 (0x00007f2180c84000) libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007f21808bb000) libz.so.1 => /lib/x86_64-linux-gnu/libz.so.1 (0x00007f21806a0000) libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007f218049c000) libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007f218027f000) libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007f217ff75000) – 고요한 Jun 07 '17 at 02:26

ibgcc_s.so.1 => /lib/x86_64-linux-gnu/libgcc_s.so.1 (0x00007f217fd5f000) libicui18n.so.55 => /usr/lib/x86_64-linux-gnu/libicui18n.so.55 (0x00007f217f8fd000) libicuuc.so.55 => /usr/lib/x86_64-linux-gnu/libicuuc.so.55 (0x00007f217f568000) libpcre16.so.3 => /usr/lib/x86_64-linux-gnu/libpcre16.so.3 (0x00007f217f302000) libglib-2.0.so.0 => /lib/x86_64-linux-gnu/libglib-2.0.so.0 (0x00007f217eff1000) librt.so.1 => /lib/x86_64-linux-gnu/librt.so.1 (0x00007f217ede8000) /lib64/ld-linux-x86-64.so.2 (0x0000564ec1cdb000) – 고요한 Jun 07 '17 at 02:27

@eyllanesc I can not run QSqlDatabase: QMYSQL driver not loaded – 고요한 Jun 07 '17 at 02:30

How have you installed pyqt? – eyllanesc Jun 07 '17 at 02:30

@eyllanesc /usr/local/lib/python3.5/dist-packages/PyQt5/Qt/plugins/sqldrivers$ ldd libqsqlmysql.so libmysqlclient.so.18 => not found – 고요한 Jun 07 '17 at 02:32

execute: `sudo apt-cache search libmysqlclient` – eyllanesc Jun 07 '17 at 02:32

@eyllanesc Pycharm settings install pyqt5 – 고요한 Jun 07 '17 at 02:33

ibmysqlclient-dev - MySQL database development files libmysqlclient20 - MySQL database client library libcrypt-mysql-perl - Perl module to emulate the MySQL PASSWORD() function libglpk36 - linear programming kit with integer (MIP) support – 고요한 Jun 07 '17 at 02:33

Do not install it through pycharm, uninstall it and run: sudo apt-get install python3-pyqt5 – eyllanesc Jun 07 '17 at 02:34

Pycharm can generate errors since the version you install may be incompatible with your OS. – eyllanesc Jun 07 '17 at 02:35

@eyllanesc'll restart it. – 고요한 Jun 07 '17 at 02:36

@eyllanesc The following packages are no longer automatically installed. – 고요한 Jun 07 '17 at 02:44

Have you uninstalled pyqt5? – eyllanesc Jun 07 '17 at 02:44

pychamr is uninstall pyqt5 Package list not pyqt – 고요한 Jun 07 '17 at 02:44

Execute: File >> Settings >> Project: your_project >> Project Interpreter and look for the package pyqt or pyqt5 or the one you have installed and uninstalled. – eyllanesc Jun 07 '17 at 02:48

@eyllanesc sudo apt-get install python3-pyqt5 It is installed. Pycharm is pyqt Uninstalled – 고요한 Jun 07 '17 at 02:56

Still the problem? – eyllanesc Jun 07 '17 at 02:57

@eyllanesc On Linux, there is pyqt. Pycharm says there are no packages. – 고요한 Jun 07 '17 at 02:58

Restart pycharm, then pycharm scans packages – eyllanesc Jun 07 '17 at 03:00

@eyllanesc yes problem – 고요한 Jun 07 '17 at 03:00

Did you restart pycharm? – eyllanesc Jun 07 '17 at 03:01

@eyllanesc restart Pyacharm no list Pyqt5 – 고요한 Jun 07 '17 at 03:02

sudo apt-get install python-pyqt5 – eyllanesc Jun 07 '17 at 03:03

You should recognize it, try to create a new project or restart your pc. – eyllanesc Jun 07 '17 at 03:05

eyllanesc Thank you – 고요한 Jun 07 '17 at 03:07

it worked?????? – eyllanesc Jun 07 '17 at 03:08

@eyllanesc pycharm Project Interpreter and look for the package No PyQT5 – 고요한 Jun 07 '17 at 03:35

Try running your project from the console: `python3 your_script.py` – eyllanesc Jun 07 '17 at 03:36

@eyllanesc python3 script.py No surch file – 고요한 Jun 07 '17 at 03:41

I think you are a beginner in linux, you have to pass the full path, goodbye – eyllanesc Jun 07 '17 at 03:43

@eyllanesc thankyou – 고요한 Jun 07 '17 at 03:47

Ubuntu Pyqt QMYSQL driver available but not loaded

0 Answers0