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