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'
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
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?
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 Traceback (most recent call last): File "C:/Users/WALTON/AppData/Local/Programs/Python/Python313/demo.py", line 9, in cur=con.connector() AttributeError: 'CMySQLConnection' object has no attribute 'connector'. Did you mean: 'connect'?
@@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
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?
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?
@@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
After writing pip install mysql-connector-python It showing defaulting to user installation because normal site-packages is not writeable Requirement already satisfied: mysql-connector-python in -packges(9.1.0)
sir when i run the codding in pythhon it shows ===== RESTART: C:/Users/slove/AppData/Local/Programs/Python/Python312/py.py ==== ================================ RESTART: Shell ================================
@@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)
After running the program I am getting "Restart shell" what to do now
is the sql query working?
Yes
cool
Really helpful. very very thanks sir.
Happy to help
Thanks alot for your help. Wonderful learning. Could build a successful connection. Thanks again
You are welcome!
Good work, thanks.🤝👍
Welcome!!
mysql is still not connecting with python ,after i run this code it shows only " -----restart:shell-----" .
please help
did the table get created in database? do you get any error logs?
Really Helpful , thank You so much
You're welcome!
(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
You did not add the python scripts path in environment variable or check the checkbox when installing python
How to do that@@unitedtoptech6288
C:\Users\\AppData\Local\Programs\Python\Python38-32\Scripts , modify this and this in your environmental variable under path
Thank you. You really helped a lot ❤❤
You're welcome 😊
super explanation. Thank you very much
Thanks man
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'
Did you pip install the packages?
Yes i did install the pip packages
so what error you got?
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
Can you try in user variable path? if system is not working
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?
Why do you want to install the older version?
@@unitedtoptech6288 because the newer version (MySQL 8. ) is not working on Windows 32-bit, Sir
Got it sir, can you try a bit newer version? 5.7 is too low
Thank you very much
You're welcome!
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.
Did you restart your cmd prompt?
@@unitedtoptech6288 Yep!
then you have added the wrong path
@@unitedtoptech6288 Alright I'll check again, Thanks for replying.
cool
("CREATE TABLE customer (name VARCHAR(255), id int);") After writing this, I am getting an error when I run it.
Please help me sir
can you paste the whole error that you get?
@@unitedtoptech6288
Traceback (most recent call last):
File "C:/Users/WALTON/AppData/Local/Programs/Python/Python313/demo.py", line 9, in
cur=con.connector()
AttributeError: 'CMySQLConnection' object has no attribute 'connector'. Did you mean: 'connect'?
con.cursor(), I used this in video, check your code
at 17.00 im not getting the dropdown option in tables
To the left in the same tab you will be having schemas, click that your database and table will be visible
@@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
Can you paste the whole error?
I got it sir, tnx
Cool sir
Inside the folder mysql server8.0, bin folder is not there. What want to do?
Ig you only installed workbench without mysql server, pls try reinstalling
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?
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?
@@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
Can you please paste the whole error sir?
'python--version' is not recognized as an internal or external command,
operable program or batch file. what should i doo
You need have space, python --version
'mysql--version' is not recognized as an internal or external command,
operable program or batch file. this is coming what should i do sir!!!
did you have space between mysql and --version when running the cmd?
After writing pip install mysql-connector-python
It showing defaulting to user installation because normal site-packages is not writeable
Requirement already satisfied: mysql-connector-python in
-packges(9.1.0)
It means you already have that package
@unitedtoptech6288 but in python it showing
ModuleNotFoundError: No module named 'mysqul'
the spelling is wrong, you have given it as mysqul
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.
you need to add mysql server bin path in environment variable
@@unitedtoptech6288sir I did that yet it's not working
you need to restart cmd too after adding and check the path too
sir the command prompt is not showing the database"newname" in it but it is showing all the other things. What should I do?
and when I am running it on python it is showing this error:
ModuleNotFoundError: No module named 'mysql.connector'; 'mysql' is not a package
Command prompt? at what timestamp do you face this?
@@unitedtoptech6288 13:10
at 13:10
Did you pip install the packages?
sir when i run the codding in pythhon it shows
===== RESTART: C:/Users/slove/AppData/Local/Programs/Python/Python312/py.py ====
================================ RESTART: Shell ================================
can you paste the other part of ur error?
@unitedtoptech6288 there is not any another error it shows only this statement restart shell
can you try using pycharm?
@@unitedtoptech6288 what is this
it is a python code editor like vs code
when I go to service to set it up as automatic, MYSQL80 doesn't show up.
Do you have mysql in your services or not?
Its says that Kernel is dead, any of you know why this might be happening and can give solution for the same,Thanks.
can you pls paste the whole error?
when i do print(con) i am not getting any error or output.why?
Can you pls paste the code?
sameeeeeeee
it is showing no output no error just the program is terminating
paste the code man
@@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)
Sir for me there was folder named bin was present help pls
In mysql?
Great video...I typed the mysql query the same way you did but I am getting programming error: 1064 (42000)
it says some issue with syntax, can you pls check?
@@unitedtoptech6288 yes, I was missing a comma. Thank you for replying. I will subscribe
Most welcome!!
can you please make a video about activity diagram and sequences diagram for expense tracking app ?
Yeah will try it!!
TQ soo much
Welcome 😊
how to connect jupyter library with mysql
What is jupyter library? never heard it? You mean notebook?
thank you SO MUCH!
You're welcome!
I LOVE YOUUUU
great