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'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, 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 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'?
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
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 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
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)
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?
(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
Thanks alot for your help. Wonderful learning. Could build a successful connection. Thanks again
You are welcome!
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
I am sorry it's my spelling mistake
But in python it shows an error
did you install the packages?
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?
After running the program I am getting "Restart shell" what to do now
is the sql query working?
Yes
cool
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
Really helpful. very very thanks sir.
Happy to help
("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
Really Helpful , thank You so much
You're welcome!
super explanation. Thank you very much
Thanks man
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
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
Thank you. You really helped a lot ❤❤
You're welcome 😊
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
Good work, thanks.🤝👍
Welcome!!
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
'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
Thank you very much
You're welcome!
'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?
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?
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?
Sir for me there was folder named bin was present help pls
In mysql?
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
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?
how to connect jupyter library with mysql
What is jupyter library? never heard it? You mean notebook?
Sir my python is not connecting after the code for connection.
😢
What's the error?
@unitedtoptech6288 no database world is found
you need to create a database named world in mysql workbench
@@unitedtoptech6288 okay sir thank you
Cool, does it work now?
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)
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 😊
thank you SO MUCH!
You're welcome!
I LOVE YOUUUU
great