No video :(

#73 Python Database Connection | MySQL

Подписаться 2,4 млн

Просмотров 773 тыс.

50% 1

Check out our courses:
Spring and Microservices Weekend Live Batch : bit.ly/spring-...
Coupon: TELUSKO10 (10% Discount)
Master Java Spring Development : bit.ly/java-sp...
For More Queries WhatsApp or Call on : +919008963671
website : courses.telusk...
Instagram : / navinreddyofficial
Linkedin : / navinreddy20
TELUSKO Android App : bit.ly/TeluskoApp
Discord : / discord
Python MySql Example
MySql Workbench and MySql Connector video: • #72 MySQL Workbench Se...
Python Tutorial to learn Python programming with examples
Complete Python Tutorial for Beginners Playlist : • #1 Python Tutorial for...
Python Tutorial in Hindi : • #1 Python Tutorial | I...
Github :- github.com/nav...
Java and Spring Framework For beginners with Spring Boot : - bit.ly/3LDMj8D
Java Tutorial for Beginners (2023) :- bit.ly/3yARVbN
Subscribe to our other channel:
Navin Reddy : / @navinreddy
Telusko Hindi :
/ @teluskohindi
Editing Monitors :
amzn.to/2RfKWgL
amzn.to/2Q665JW
amzn.to/2OUP21a.
Donation:
PayPal Id : navinreddy20
Patreon : navinreddy20
www.telusko.com...

Опубликовано:

26 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 547

@krishnajunk 5 лет назад

I watched whole of these Python playlist and learnt the Python for FREE. Thanks a lot. Appreciate your teaching and work :-)

@darshaanaghicha8023 2 года назад

One correction, if you are watching in 2022 @04:00 you might be getting "Authentication plugin 'caching_sha2_password' is not supported" error. Just uninstall mysql-connector & install mysql-connector-python.

@sunitatanwar7866 2 года назад

How to uninstall it...

@darshaanaghicha8023 2 года назад

@@sunitatanwar7866 pip uninstall mysql-connecter

@asphalt9legends994 Год назад

Thank you very much .

@rawnesswithmark9059 3 месяца назад

You sir are a legend. Works even in 2024

@seemapandey4826 2 месяца назад

Thanku soo much bhai

@meghanam7550 3 года назад

I learnt python by seeing all your videos . Hats off to you sir 👏

@jdiez7092 4 года назад

Probably the best explanation of how to connect to MySQL ever !!

@printhouse6191 3 года назад

same prob me also.....

@swadhikarc7858 5 лет назад

Couple of years ago I used to be your channel fan for Java. However, now you're rocking in python. You're definitely a master of all trades. Kudos you talent

@SumanthLazarus 4 года назад

Thanks mate. What is the difference/purpose between using 'mysql-connector' vs 'sqlalchemy' ?

@zakiasmaa6834 7 дней назад

want to start by thanking you sincerely for all the effort you've put in-you're truly the best. After following your Python series, I feel confident that I've grasped all the key concepts. However, I'm wondering if you've covered Python scripting and Robot Framework somewhere, as I couldn't find any content on that in your channel. Could you please let me know if you've explained those topics? Thank you!

@kanishkmewal3885 3 года назад

Visual Studio is Baap! 🔥 Using it since i was 13 years old

@Ian-pc2mn 3 года назад

how do you connect with vs

@abhinavthapliyal8322 3 года назад

tu kon hota hai be baap banane wala.

@News_Shorts- 3 года назад

@@abhinavthapliyal8322 hmm.. but even i use it

@julianjohnmert8658 4 года назад

Hey Navin, when I start working and earning a salary I'm donating I promise. I mean I am totally straight but I have never loved another man this much.

@abhayasharma7065 3 года назад

@sagarrao79 5 лет назад

Pychram or Sublime error: if you have mysql 8.0.15 version , then you need to have mysql connector-8.0.15 Open Pycharm go to File->Settings-> Preferences->Project->Python Interpreter inside Pycharm, and search for mysql-connector-python and select version as 8.0.15 from dropdown list and click in install. for Sublime: go to command prompt, uninstall any old mysql connector pip3 uninstall mysql-connector C:\Users\Sanju>pip3 uninstall mysql-connector pip3 install mysql-connector-python C:\Users\Sanju>pip3 uninstall mysql-connector-python

@gamkht 5 лет назад

Thank you very much! I had the problem ' Authentication plugin 'caching_sha2_password' is not supported' and this fixed it for me

@selcukdoven 5 лет назад

Hi, Firstly I want to thank you for this useful video series. Could you please release the Oracle/Mango database connection and basic queries. A lot of people use these databases. Thank you so much.

@kerthikeyan7346 3 года назад

really you are alien......helped me a lot everytime I search something I am ending up with your solution....its really working out for me....

@ValorantEdits 3 года назад

Who all are watching 1 day before Practical exam

@premstein16 5 лет назад

Navin, can't find the pip3 installation vdo which you where mentioning.

@alcaravan555 4 года назад

I had the same situation, the way I solved was to go where python is located, in my case c:\users\myname\python\pip3 install mysql-connector, I hope this helps

@agbojoraphael7868 5 лет назад

Great job Navin. Your series have been really helpful. I've learnt a lot. I'd appreciate if you can do also on Big data using python. Looking forward to it so much.

@nortonnnantikill403 5 лет назад

Well explained thank you very much Sir

@rizaldycesarquimno1058 4 года назад

When I import the mysql.connector it raises ModuleNotFoundError error?

@arindammallick9034 5 лет назад

please make a video on python with mysql using xampp

@maitreyeedey5960 2 года назад

your videos are really helpful to me.. thank you very much

@user-jk6yr4ew2e 5 лет назад

hello im korean student i had saw this video so i want to talk you very appreciate.

@nothingspecial7163 3 года назад

U mean `thank' ?

@user-jk6yr4ew2e 3 года назад

@@nothingspecial7163 yes!!! hahah

@PavanKumar-by8dc 4 года назад

Inserting values into tables , after the line mycursor insert = ' ' ' INSERT INTO STUDENT VALUES ( 106 , ' PAVAN ' ) ' ' ' mycursor.execute( insert)

@moinafsana5945 5 лет назад

Those who have facing connection problem need to install two pckg 1st mysql-connector 2nd mysql-connector-python *** if you are using workbench 8.0 CE

@anandvardhan4996 4 года назад

It worked for me. Thanks for the solution

@omkartaur3887 5 лет назад

Your all series videos are awesome and brilliantly explained. Can you also please make tutorial on ' tkinter GUI ' ?

@sandeepsinghnegi6348 4 года назад

I recommend people to first uninstall mysql-connector and than install mysql-connector-python as there should clash between both of than while importing library

@umamaheshkummari7987 5 лет назад

description box link didn't help to solve pip3 not found error.Please help us.Thanks in advance.

@maniksayal2496 5 лет назад

hey uma I was also getting the same problem. To solve it just see the video of setting up the path video from this playlist and then try cmd prompt pip3/3.7(depends upon the version you are using) install MySQL-connector

@john16584 5 лет назад

please use this command on cmd ""pip install mysql-connector-python"" this will solve the issue.thanks

@roshnimehta9070 2 года назад

Thanks a lot it helped me .I am trying from so many days I had seen lot of video but never work. But this video clear my problem.

@avisekdey2224 5 лет назад

Really nice sir. Content is very good and to the point.

@watchout1435 4 года назад

if your cmd cant find pip or pip3 just go to python's official website and download the latest version of python and then try pip on your cmd , worked for me

@Family_12362 11 месяцев назад

Super Explanation Sir👌👉.

@PavanKumar-by8dc 4 года назад

Thanking You for kind this Stuff and Encouragement...this is really best to everyone.. You are a real master, without skip any , and u thought as everything which is related to Python...

@shanuchauhan4814 5 лет назад

Best video on you tube ,Your Explanation is very good child can understand your tutorials easily

@benjenne8744 4 года назад

If anybody gets a dumb error try adding use_pure = True: mydb = mysql.connector.connect(host="localhost", user = "root", passwd = "password", use_pure = True)

@Rajadahana 2 года назад

I don't know anything about MySQL, so I got the message. I need to learn it, first I will finish this playlist and learning MySQL will be my next endeavour. A BIG thank you to the whole team behind this effort.

@MSAbhi-gj8pn Год назад

Can you plz share from where you are learning SQL?

@sapl923 5 лет назад

i am learning and understanding better than my whole month classes thanku sir

@Family_12362 11 месяцев назад

Sir ,can we use Thonny IDE

@salihaider6100 5 лет назад

Make a video on beautifulsoup/webscrapping. Please.

@rajibguha6960 5 лет назад

After install mysql.connector show error into Pycharm such as "ModuleNotFoundError: No module named 'mysql.connector'". Now pl give suggestion, what to do ?

@hafizabdulrehmaniqbal3968 5 лет назад

Help to fix pip3 install Its giving syntax error

@krishnaKumar-zi6ct 4 года назад

Clear steps to establish connection and try initial queries. Thanks Navin!

@wasteyourtime02 3 года назад

this guy is the best i wish i had found this channel earlier

@kuruvellameghana2627 5 лет назад

Sir , I have installed MySQL and had run the code in sublime editor ,but I have got error (MySQL module donot found) but when I run in python shell I got answer.plss ,help me sir

@omegamagna 4 года назад

same.

@dathashiva 3 года назад

I'm a new user of ubuntu for installation of MySQL taken the whole day. Atlast it worked.

@infiniteesh 4 года назад

When I try to connect python with mysql in sublime I get an error Error : Authentication plugin 'caching_sha2_password' is not supported

@aarongeorge579 4 года назад

Hi, watch his previous video and follow the steps of installation. I to had this same error and it got fixed by following his way.

@feynmansscholar6471 4 года назад

u must set a path........ "\cd"....... try this b4 install it might work then.

@RetroRampageArcade 5 лет назад

mysql module not installed error solution(pycharm) file > settings > project > yourproject >project interpreter > click plus button> search for mysql-connector > install

@vijayadurga812 4 года назад

Error visual studio ++ something what is the solution for this

@nishaagarwal3659 4 года назад

@badar munir error is being occured in my pc even after doing the above thing

@Negroblancobala 5 лет назад

Thanks Navin for the simple and informative video.

@worldofai6406 4 года назад

can we use Xampp myphpadmin instead of MySQL workstation?

@nityasoni7433 3 года назад

Sir pls explain database connectivity with pycharm also....I m using pycharm from ur starting video

@abinashlenka9455 4 года назад

Actually am getting a module not found error while running the python code on command prompt , so can u plz let me know y bcz i have already installed the connector but still i am unable to run d Python code

@ryan.aquino 4 года назад

What is better for production builds? and large scale applications. Do we use ORM like SQLAlchemy? or just a connector. If performance is the metrics

@dudu_bubu14 3 года назад

Superb sir Thank you so much without your video it is not possible to connect python with mysql

@mukeshtiwari3131 5 лет назад

in sublime the message Can't connect to MySQL server on 'localhost:3306' (10061 No connection could be made because the target machine actively refused it) also appears.

@babinollaramu6011 4 года назад

Same problem

@ivansaiji 4 года назад

Thank you so much! Simple and to the point! Worked like a charm!

@Chhiling08 5 лет назад

I always watch your video sir u r very good teacher 😊😊

@vivekgupta5041 3 года назад

Very useful and helpful video to get started with python and MySQL !!!

@vaishakhkp5612 5 лет назад

This is really helpful, could you please explain about posting data from a html for to the database for user registration and login using python.

@amoghranganath4155 4 года назад

Sir, the best guide you are, simple and to the point

@amoghranganath4155 4 года назад

Sir, for Python, we need to do pip3 install mysql-connector-python

@PavanKumar-by8dc 4 года назад

@@amoghranganath4155 that is for installation in PyCharm , not for Sublime text

@misikoala6368 2 года назад

Wow, you are an angel! Thanks for the teaching.

@adultcasm6385 4 года назад

HEY! '' TECHNICAL TACLU '' YOU R OSSUM

@luciferkhusrao 4 года назад

hahahahhaahhahahahahahahahahhahahahahah

@1112sravani 5 лет назад

It would be really useful...Recently i have done some project for which I needed a video like this very badly.. I've had to watch so many videos to complete it..Nobody is as good as u

@PITCLLCUSA Год назад

Awesome and very easy to connect, only I struggle while installing mysql connector

@samarpratapsingh9788 3 года назад

I got the following error mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported

@parthchawla8385 3 года назад

then you are entering the wrong password or you have some problem with the connector

@marthalanaveen 4 года назад

as of november 6, 2019, line 3 from code at 3:39 won't work. instead do mydb = mysql.connector.connect(user='navin', password='1234', host='localhost', auth_plugin='mysql_native_password') and that works. you should also have 'mysql-connector-python' and 'mysql-connector' installed.

@ashishanjana7403 4 года назад

are mysql-connector-python and mysql-connector both different from each other...?

@abhirana8422 4 года назад

I am having this type of error "Authentication plugin '{0}' is not supported".format(plugin_name)) NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported

@Rocky-me7qh 5 лет назад

You are great sir

@oscarvargas4992 2 года назад

this video was very successful for me

@rojertufani131 3 года назад

Thank you so much sir.. I have run this code in VS code and it is still working

@chaitanyakrishna9398 4 года назад

sir, I am a complete beginner in python. I am learning python from it's word meaning, from you. But this video creating a fear that I need some programming background to watch upcoming playlist videos. Is it true sir. If yes please help me .....sir

@sunkojuanusha2821 4 года назад

Shall i write this program in pycharm please let me know. I have tried to write in pycharm but getting an error as no module named 'mysql '

@codingwithparamesh7496 3 года назад

The video was very nice. All it compromises of useful informations.

@rizaldycesarquimno1058 4 года назад

Is the installation of my-sql-connector one time or everytime you have will connect my-sql to python?

@pawanggamer6937 3 года назад

one time only but you need to import module in python while using mysql

@ashishanjana7403 4 года назад

how to use sublime here do i need to install it first? if so, from where please guide me sir... thanks a ton for this series...lots of respect for you and your work...

@sassyjas1313 5 лет назад

no video for pip3 error. please help!! Thank YOu

@rahulkumarc341 5 лет назад

Did u got solution ? is pip3 working? if so please help me.

@vikasms9113 5 лет назад

set the path thats it

@tanishq2766 4 года назад

Use the command mysql-connector-python rather than using mysql-connector while using the pip install....(if ypu are using the latest version of MySQL its 8.0.7 i guess) Regards:- Tanishq:)

@vanithas2701 2 года назад

Den how to import the mysql module in code

@tanishq2766 2 года назад

@@vanithas2701 import myql-connector

@ishugoyal5781 4 года назад

i have installed the connector still in pycharm its showing no package with tha name

@yashasvibhatt1951 4 года назад

type this *"python -m pip install mysql-connector-python"* if you still have problem

@shricharanb7914 4 года назад

I too get that 🥺 Please help !

@arslankabeer3951 5 лет назад

my sublime is showing an error for fetchall and fetchone method why?

@GladanDsouza 3 года назад

For those students whose output isn't showing properly first install the correct packages properly. Download Pycharm community edition first then got to File then settings. Over there under python interpreter click on the plus icon on top and search mysql-connector-python. Download it and your good to go.!!!

@pro_fessor. Год назад

And showing, module 'mysql.connector' has no attribute 'connect' Any solutions.?

@SohamPhadke 4 года назад

Any reason why sublime text was used instead of pycharm ?

@BringMe_Back 2 года назад

GOD sir ji : i watched both the videos , its much helpful

@ajithpkumar1507 2 года назад

Great explanation

@himanshuchoudhary8222 4 года назад

I'm very glad to see your video...and keep giving such kind of knowledge full of our study.......stay happy and blessed

@anastariq1310 4 года назад

while doing database connection this error pops up "Authentication plugin 'caching_sha2_password' is not supported"......Can anyone help to solve this

@brijesh9670 4 года назад

cnx = mysql.connector.connect(user='', password="", # required port=port_number, host="localhost", # required database='database_name', auth_plugin='mysql_native_password' # required ) MySQL Command Line Client ALTER USER 'root'@'localhost' IDENTIFIED BY 'your_password' PASSWORD EXPIRE NEVER; ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_password'; you_password is the password you use to sign in your mysql try these commands as well as add auth_plugin

@kamleshzanjad263 Год назад

Great learning... It was great learning experience.

@vishutanwar 3 года назад

mysql.connector.errors.InterfaceError: 2003: Can't connect to MySQL server on 'localhost:3306' ( No connection could be made because the target machine actively refused it) if you are getting this error maybe you changed port number , don't uninstall that just change back port number

@hemantpal1354 3 года назад

same error here btw wht is port number, How to chnge??

@deepasakthi9653 4 года назад

You really made it simple, thanks a tonn

@mayanegi6839 5 лет назад

"pip3" is not working in my system. Sir can you please tell how to make it work or any alternative method.....

@vandanaarya1465 2 года назад

Great video and platform to learn quick and easily.

@zakinaqvi998 2 года назад

Thanks for uploading such an informative video

@RajeshKumar-fu2cy 3 года назад

thank you for this video....please do video for oracle 19c with python .....if you have time

@aadeshshinde9129 3 года назад

Oswaal book scan kiya to idar redirect kiya wow🤩🤩

@vijaybhaskar689 3 года назад

This is great. I hope you the similar process for IBM DB2. If you have that video can you Please share 😊

@samankushwaha6188 2 года назад

Sir the way you call us aliens is preety nice 😂 i love that, and you helped me alot in my 11th and 12th currently I'm giving my pre boards and im still depend on you video Thanku so much sir ❤️

@aashankkalia4464 2 года назад

Very informative. Thank You!

@namanb12 5 лет назад

Solution to Access Denied Error Run the same command which he ran initially but run cmd as an administrator. This can be done by right clicking on cmd and selecting run as administrator. This worked for me hope it does for all.

@imsaiiif199 4 года назад

Sir this command in pycharm giving error.saying,no module named mysql

@lakshit6429 3 года назад

thankyou very very very muchhh sir i was too much confused with this concept

@mobilitynuggets2094 5 лет назад

Getting error while connection ConnectionRefusedError: [WinError 10061] No connection could be made because the target machine actively refused it.

@TechWithRushabh 4 года назад

Same here! any solution

@yigitgenc1734 4 года назад

while putting in the "host" variable you put localhost there but if you were hosting this database on a website what were you supposed to put? The websites link or the ip address of that website?

@GAMINGWITHDESTRYER 4 года назад

If you guys getting error like me go to the folder where Python is installed press shift+RMB and click open PowerShell here and write the code below : C:\Users\thede\AppData\Local\Programs\Python\Python38> py -m pip install mysql-connector