Thank you so much. This video is old and I ran into some bugs trying your method, but I managed to figure them out. Leaving this comment here in case I have to come back to it on a different computer. For the IDLE app: At about 2:53, you say to type "pip install mysql-connector", and unfortunately at the time of this comment, this is depreciated. Instead use "pip install mysql-connector-python". At 4:15 I noticed you did a ninja edit where you changed the "mydb = sql.connector" line to "mydb = sql.connect" and this is important. Finally, I was confused because I had multiple Python versions installed. 3.9, 3.10 and 3.11 (I know bad practice on my part). Make sure you are using the same version for both pip install and IDLE shell. For Jupyter Notebook: I ran into another error when I tried to run the mydb command, which was "mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported". To solve this, I created a cell and ran "pip install mysql-connector-python" prior to trying it again.
@@aminatyusuff6921 Thank you. Word of advice for whenever you run into bugs when programming: Try copying and googling the exact text of the error message. More likely than not, you'll find a solution on stackoverflow. You may have to do some trial and error.
@@shabbirgovernor sir I have a problem actually while writing the code in idle Here attribute error is being shown that mysp.connctor has no attribute connector how to fix this
I am getting this error... Authentication plugin 'caching_sha2_password' is not supported when trying to create a connection between jupyter notebook and mysql.... Kindly guide how to resolve
@@m38jazzsilver oh i found the solution to it...u just need to uninstall anaconda and python from ur pc then install python again but this tine add it to your PATH then download the module...it worked for me hope ur problem get solved Ohh and u can reinstall conda after it if needed
Thank you so much. This video is old and I ran into some bugs trying your method, but I managed to figure them out. Leaving this comment here in case I have to come back to it on a different computer.
For the IDLE app: At about 2:53, you say to type "pip install mysql-connector", and unfortunately at the time of this comment, this is depreciated. Instead use "pip install mysql-connector-python". At 4:15 I noticed you did a ninja edit where you changed the "mydb = sql.connector" line to "mydb = sql.connect" and this is important. Finally, I was confused because I had multiple Python versions installed. 3.9, 3.10 and 3.11 (I know bad practice on my part). Make sure you are using the same version for both pip install and IDLE shell.
For Jupyter Notebook: I ran into another error when I tried to run the mydb command, which was "mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported". To solve this, I created a cell and ran "pip install mysql-connector-python" prior to trying it again.
You are beautifully blessed. You can't imagine how you just saved me from giving up when I'd barely started. 😊
@@aminatyusuff6921 Thank you. Word of advice for whenever you run into bugs when programming: Try copying and googling the exact text of the error message. More likely than not, you'll find a solution on stackoverflow. You may have to do some trial and error.
Very informative....thanks a lot for sharing :)
Thanks bro lot of video I watched but you did it
I was in trouble as how to connect to mysql . But this video resolves it . These commands really work . Thankyou Shabbir for this awesome video....
Glad to help mate!🙂
@@shabbirgovernor sir I have a problem actually while writing the code in idle Here attribute error is being shown that mysp.connctor has no attribute connector how to fix this
Thank you.
Great video 😊
after writing cd Scripts it still shows the system cannot find the path specified... what am I supposed to do now?
same here :(
thank you so much mate
Many Many Thanks.... This video solved my problem. Thanks a lot.
🙂
In my case it is showing connection refused error. Please help me how to resolve this issue.
3:09 how i can open thes pega
Scripts -showing the system cannot find path
Thank you ❤
tagri
I am getting this error... Authentication plugin 'caching_sha2_password' is not supported
when trying to create a connection between jupyter notebook and mysql....
Kindly guide how to resolve
I am getting the same error, did you ever resolve it, plz tell me how if you did.
Mysql is connected toh jupyter but when i am using import mysql.connector in shell its showing module not found
The same here @Saksham
@@m38jazzsilver oh i found the solution to it...u just need to uninstall anaconda and python from ur pc then install python again but this tine add it to your PATH then download the module...it worked for me hope ur problem get solved
Ohh and u can reinstall conda after it if needed
Thanks Bro for the video. Do more videos like this.
Sure
it's showing no module named mysql and I have already installed the pip
Same
😢 ERROR :No module named 'mysql.connector'
pip install it
@@shabbirgovernor It is already installed. 😶
I tried with : pip install mysql-connector-python it worked ..
Sir pip command work nahi kar rahi
Sad bro