PyQt5 Mysql Database Connection #33

Join My PyQt6 13 Hours Course in Udemy

This is our thirty third video in pyqt5 gui programming, in this video iam going to show you how you can connect your pyqt5 application in mysql database, we are using wamp server for this also we are using mysqlclient package for connection

for installing mysqlclient package
pip install mysqlclient

Playlist For PYQT5 GUI Programming

[syedsunairinam]

Hi Parwiz, could you please share the code of every video in the description. It's quite difficult to write code by tapping alt+tab again n again. Thank you

[oscaralba]

Hi Parwiz . I use Python 3.7 and can't use the module, because the message:

ModuleNotFoundError: No module named 'MySQLdb'

I update with mysql-connector-python 2.0.4 (pip3 install) and also saw the same error. Colud you help me Please?. Thanks for your attention.

[reezalaq]

Please create a video about how to create a form so you can change database connection credentials and then press connect. Thank you.

[DerpRenz]

Mine will not connect. I created a databse called pyqt5 in the sql command line and used the same code as you except i had a password.

[crypto-knight]

is this playlist for someone whos trying to do a proj of webpage using pqt and mysql? coz im a beginer and thats what i need.
Thankyou

[ernanfer]

Hi, good vídeo. I have a problem with qsqldatabase (qsqlite) it connect well but when i'm insert data not work...please help me

[DerpRenz]

Error is : (2059, "Authentication plugin 'caching_sha2_password' cannot be loaded: The specified module could not be found.\r\n")

[-bbbc]

Traceback (most recent call last):
File "/data/user/0/ru.iiec.pydroid3/files/temp_iiec_codefile.py", line 5, in <module>
import MySQLdb as mdb
ModuleNotFoundError: No module named 'MySQLdb'

[pragatigupta]

Hi i got this error
import MySQLdb as mdb
ImportError: No module named 'MySQLdb'

[pragatigupta]

but my code run in idle 3.5.please help me

[romeofernandeziii]

Thank me later.
pip install mysqlclient==1.3.12

[oscaralba]

I myself found the solution... is just "import mysql.connector" ....