Connect Mysql Database using Python Tutorial | MySQL server and Workbench 2024

[@user-jb9ed6pv8e]

Sir, I'm using Windows 10 32-bit. I tried to install mySQL 5.7, like the video in 04:06 it only showed MySQL Server and Documentation, I'm not getting Applications. Do you perhaps know why did it happened?

[@unitedtoptech6288]

Why do you want to install the older version?

[@user-jb9ed6pv8e]

@@unitedtoptech6288 because the newer version (MySQL 8. ) is not working on Windows 32-bit, Sir

[@unitedtoptech6288]

Got it sir, can you try a bit newer version? 5.7 is too low

[@Aravinthravi-mc9nh]

(Pip is not recognized as an internal or external command ,operable program or batch file.). I got the error how to solve this error in command prompt

[@unitedtoptech6288]

You did not add the python scripts path in environment variable or check the checkbox when installing python

[@niranjanapr6696]

How to do that​@@unitedtoptech6288

[@unitedtoptech6288]

C:\Users\\AppData\Local\Programs\Python\Python38-32\Scripts , modify this and this in your environmental variable under path

[@SwatiKathuriaGDGGS]

Thanks alot for your help. Wonderful learning. Could build a successful connection. Thanks again

[@unitedtoptech6288]

You are welcome!

[@rishiksahu2007]

It's still showing the error👇🏻 Traceback (most recent call last): File "C:/Users/Rishik/Documents/Python Programs/Python connectivity.py", line 1, in import mysql.connector ModuleNotFoundError: No module named 'mysql'

[@unitedtoptech6288]

Did you pip install the packages?

[@sahildhabu7515]

Yes i did install the pip packages

[@unitedtoptech6288]

so what error you got?

[@addyakumari7840]

Hey, I did save my sql in environment variable but then to I'm getting in the command prompt that it is not recognized as an internal or external command. Please help me.

[@unitedtoptech6288]

Did you restart your cmd prompt?

[@addyakumari7840]

@@unitedtoptech6288 Yep!

[@unitedtoptech6288]

then you have added the wrong path

[@addyakumari7840]

@@unitedtoptech6288 Alright I'll check again, Thanks for replying.

[@unitedtoptech6288]

cool

[@SheebaY-q3b]

Really helpful. very very thanks sir.

[@unitedtoptech6288]

Happy to help

[@Harshika__C]

Sir when I am visiting environment system variable everything is looking same as your computer but when I am clicking on edit path the same screen or the option of adding a new path is not appearing. Instead there is option for editing just one path,the one I clicked Please help sir i need to do a school project

[@unitedtoptech6288]

Can you try in user variable path? if system is not working

[@dilansarith2188]

super explanation. Thank you very much

[@unitedtoptech6288]

Thanks man

[@rimachakraborty1458]

Really Helpful , thank You so much

[@unitedtoptech6288]

You're welcome!

[@Just_A_Tech.._]

Good work, thanks.🤝👍

[@unitedtoptech6288]

Welcome!!

[@official_bqpro]

Thank you. You really helped a lot ❤❤

[@unitedtoptech6288]

You're welcome 😊

[@SheebaY-q3b]

Inside the folder mysql server8.0, bin folder is not there. What want to do?

[@unitedtoptech6288]

Ig you only installed workbench without mysql server, pls try reinstalling

[@MrDheeraj777]

'python--version' is not recognized as an internal or external command, operable program or batch file. what should i doo

[@unitedtoptech6288]

You need have space, python --version

[@MOHAMEDFOWAZMMSEC]

at 17.00 im not getting the dropdown option in tables

[@unitedtoptech6288]

To the left in the same tab you will be having schemas, click that your database and table will be visible

[@MOHAMEDFOWAZMMSEC]

@@unitedtoptech6288 yes sir I got it, I have a problem with my python connection with my SQL with SQL alchemy error to do hotel food order system, could u help

[@unitedtoptech6288]

Can you paste the whole error?

[@MOHAMEDFOWAZMMSEC]

I got it sir, tnx

[@unitedtoptech6288]

Cool sir

[@Pari-gb7wo]

'mysql--version' is not recognized as an internal or external command, operable program or batch file. this is coming what should i do sir!!!

[@unitedtoptech6288]

did you have space between mysql and --version when running the cmd?

[@Kixishiva]

This is not working for me what should I do?? 'mysql' is not recognized as an internal or external command, operable program or batch file.

[@unitedtoptech6288]

you need to add mysql server bin path in environment variable

[@Mahalakshmi-jr4di]

​@@unitedtoptech6288sir I did that yet it's not working

[@unitedtoptech6288]

you need to restart cmd too after adding and check the path too

[@mahtha-e3q]

when I go to service to set it up as automatic, MYSQL80 doesn't show up.

[@unitedtoptech6288]

Do you have mysql in your services or not?

[@sudhirdutt1]

sir the command prompt is not showing the database"newname" in it but it is showing all the other things. What should I do?

[@sudhirdutt1]

and when I am running it on python it is showing this error: ModuleNotFoundError: No module named 'mysql.connector'; 'mysql' is not a package

[@unitedtoptech6288]

Command prompt? at what timestamp do you face this?

[@sudhirdutt1]

@@unitedtoptech6288 13:10

[@sudhirdutt1]

at 13:10

[@unitedtoptech6288]

Did you pip install the packages?

[@KanilPatel]

Its says that Kernel is dead, any of you know why this might be happening and can give solution for the same,Thanks.

[@unitedtoptech6288]

can you pls paste the whole error?

[@MRBULLSEYE3454]

mysql is still not connecting with python ,after i run this code it shows only " -----restart:shell-----" . please help

[@unitedtoptech6288]

did the table get created in database? do you get any error logs?

[@kennethdarby899]

Great video...I typed the mysql query the same way you did but I am getting programming error: 1064 (42000)

[@unitedtoptech6288]

it says some issue with syntax, can you pls check?

[@kennethdarby899]

@@unitedtoptech6288 yes, I was missing a comma. Thank you for replying. I will subscribe

[@unitedtoptech6288]

Most welcome!!

[@RLingeshwaran-r3g]

Sir for me there was folder named bin was present help pls

[@unitedtoptech6288]

In mysql?

[@lekhashri3558]

Am doing my mini project using vscodes but i am working with only frontend which is html,js,css.. but i need database for that.. and now with the help of ur video i connected MySQL with python but now how can i connect this with my vscode?

[@unitedtoptech6288]

So you want a way to get data from your frontend which I assume has input boxes in the UI and they need to be then stored in mysql DB with the help of python?

[@MOHAMEDFOWAZMMSEC]

@@unitedtoptech6288 yes sir it showed, now i m doing a hotel food order project with python and my SQL in workbench where I'm getting SQL alchemy error where I installed it and tried many ways where it is not working, could you help

[@unitedtoptech6288]

Can you please paste the whole error sir?

[@bluepixel-nr2rh]

when i do print(con) i am not getting any error or output.why?

[@unitedtoptech6288]

Can you pls paste the code?

[@palkisachdeva8246]

sameeeeeeee

[@palkisachdeva8246]

it is showing no output no error just the program is terminating

[@unitedtoptech6288]

paste the code man

[@SK-oe5fs]

@@unitedtoptech6288 it dosent show any output or error it just isnt giving any output after i hit run, the shell opens n thats all i can onlly see my cursor blinking n nothing coming this is the code i ran :- import mysql.connector con=mysql.connector.connect(host='localhost',user='root',passwd='root') print(con)

[@Pb_insane]

sir when i run the codding in pythhon it shows ===== RESTART: C:/Users/slove/AppData/Local/Programs/Python/Python312/py.py ==== ================================ RESTART: Shell ================================

[@unitedtoptech6288]

can you paste the other part of ur error?

[@Pb_insane]

@unitedtoptech6288 there is not any another error it shows only this statement restart shell

[@unitedtoptech6288]

can you try using pycharm?

[@Pb_insane]

@@unitedtoptech6288 what is this

[@unitedtoptech6288]

it is a python code editor like vs code

[@MuhammadIbrahim-nb7ie]

can you please make a video about activity diagram and sequences diagram for expense tracking app ?

[@unitedtoptech6288]

Yeah will try it!!

[@monuoriginal7425]

how to connect jupyter library with mysql

[@unitedtoptech6288]

What is jupyter library? never heard it? You mean notebook?

[@anbarasisrihari3088]

TQ soo much

[@unitedtoptech6288]

Welcome 😊

[@JSamuel08]

thank you SO MUCH!

[@unitedtoptech6288]

You're welcome!

[@elitezzeisa1645]

I LOVE YOUUUU

[@unitedtoptech6288]

great