Using MySQL Database With Kivy - Python Kivy GUI Tutorial #56

In this video I'll show you how to start using the MySQL database in your Kivy Apps!

Using MySQL with Kivy is pretty easy, I'll walk you thru it in this video.

We'll start out by downloading MySQL, then we'll pip install the mysql connectors that allow our python app to connect to Mysql.

Then we'll configure a MySQL connection, and create a database and table, and go from there!

Install MYSQL:

MySQL Connectors:

pip install mysql-connector mysql-connector-python mysql-connector-python-rf

#kivy #codemy #JohnElder

Timecodes

0:00​​ - Introduction
1:24 - Download and Instal MySQL
3:55 - pip install MySQL Connectors
7:47 - Create MySQL Connection
9:31 - Create MySQL Cursor
9:53 - Create MySQL Database
10:55 - Check To See if Database Created
12:25 - Create Database Table
13:34 - Check To See If Tabel Created
15:39 - Add Record To Database
18:10 - Show Records
19:00 - Test It Out!
19:29 - Conclusion

[Codemycom]

▶️ Watch Entire Kivy Playlist ✅ Subscribe To My YouTube Channel:
▶️ See More At: ✅ Join My Facebook Group:
▶️ Get The Code

[hermanAfandiu]

That's fantastic. Really good for beginners.

[kowalskime]

Thank you for you and your all free lessons and please keep going and teach us new programming languages like Java, Javascript, and other amazing languages🙌🙌🙌🙌

[barucaguilar]

Excellent video, thank you very much!

[mokshbhatnagar]

Can you please make a video on how to add scrollable widgets in kivy because when the text covers more space then we cant scroll to check the remaining text and it really messes things up...

[mounikaa]

hii can u help me the code for buliding the challenges in the diet recall app by using kivymd by connecting the database

[svendzeble]

Hi. Great video but the first time you ran the app, mine gave me an error like this ....

Authentication plugin 'caching_sha2_password' is not supported


would appreciate if I could get some help, thank you.

[CRFigueroa]

good tutorial!!!
It would be great if you could do a tutorial on how to connect the app to an API, greetings!!

[timmilot]

great tutorial! I ran into: raise InternalError("Unread result found") Unread result found
which adding (buffered=true) to cursor definition fixed

[landthanhyen]

Hi! Thanks for these instructions! Can you use tableWidget With Kivy to connect to SQL Server?

[infinitespace]

Hi, I was wondering can you please make a tutorial as to how to launch an app made from kivy on the playstore AND on the appstore, you don't actually have to do, just describe the process step - by - step. My other question is if I launch an app made from kivy that uses MySQL, will the same database work for all those around the world who want to download the app? Or is thre another way to tackle it?

[rodolfoblasser]

Nice! It would be interesting to see how to compile this into an apk for mobile use.

[heddaolsen]

Is it possible to connect a KivyMD DropdownMenu to mysql database? I want to fetch rows from a mysql table and insert into the dropdown menu one by one.

[harshulanand]

Will the app still work on other devices? Like we are just providing the password for sql on our device .

[james.]

Hi sir, can you show your table in database after you add inputted data?

[tejasrathi]

Please do a tutorial on Password manager using Kivy and MySQL

[devinsmith]

Results in the window are limited to 6 lines, I thought something was wrong with my code at first..