Articles , Blog November 6, 2019 29 Comments MySQL Database with Python Tutorial Part 1 – Intro Related posts: Introducing Azure Database for PostgreSQL and Azure Database for MySQL SQL Databases and the Firebase Database – The Firebase Database For SQL Developers #1 Firebase Database Querying 101 – The Firebase Database For SQL Developers #3 Microsoft Access Rental Database Template TAGS and, database, hosting, How-to (Media Genre), MySQL (Software), mysqldb, Python (Software), Python programming language, SQL, the, tutorial, Websites, you Daniel Ostrander Post navigation AZURE CONTAINER REGISTRY-INTRODUCTIONSecuring your data structure with Security Rules – The Firebase Database For SQL Developers #8 Related Posts December 30, 2019 When and how to use a dictionary – and when NOT to use a dictionary! December 30, 2019 Should I Host My Blog on a Subdomain, Sub folder, or Separate Website? December 30, 2019 Metadata, Agility, and Consensus – Tech Forum 2019 29 thoughts on “MySQL Database with Python Tutorial Part 1 – Intro” iuliqu says: November 27, 2013 at 5:36 pm great! Reply Chris Kavanagh says: November 30, 2013 at 8:04 pm Great! Thanks. Reply Chris Kavanagh says: November 30, 2013 at 8:08 pm You could always use WAMP if your on windows, since it includes MYSQL. Plus it gives you the server you need. Reply abdulrahman Ahmed says: January 4, 2014 at 8:58 am you talking too much! Reply Four Noble Truths says: November 11, 2014 at 9:30 pm @ChangeTip quarter Reply Robert's Take says: January 21, 2015 at 4:54 am do we need to download mysql or can we jump right in with this program Reply Mehmet YÜCE says: September 27, 2015 at 6:49 pm https://www.youtube.com/watch?v=lhU2OZCKXhQ Reply Saad Fazelpour says: April 14, 2016 at 12:52 am These series didn't teach me how to install any of the modules needed to connect to mysql from python which is the most important part. At best i call this series add hoc and amateurish. No comprehensive tutorial. Don't waste your time on these tutorials. Reply Anthony sanchez says: July 19, 2016 at 12:17 am hi derek, im having trouble running an application. i have to connect the log in to mysql data base and from the data base the application gets username, password, ect. i was wondring if you can help me out set up my data base. im , im currently using xammp my sql and im only confused on where i have to set the users. on rows and rows. is there any way i can contact you so i can send you the script? Reply Adriel Vieira says: October 15, 2016 at 10:25 pm dude, you have done a tutorial for half of the things I try to learn on the internet. thank you! Reply hgamalm says: November 10, 2016 at 4:12 am Thank you for these tutorial. I wanna know if I can run the python code from outside pythonanywhere and access the database. Reply Sharma Yeshu says: January 4, 2017 at 4:18 am It is showing an error while running the mysql command in the bash consoleERROR 2005 (HY000): Unknown MySQL server host 'mysql.server' (0 Reply Calvin Makokha says: January 18, 2017 at 8:40 pm Thanks for tutorials..really wondering what in Python you have not done…thanks for all vids Reply Harold Crow says: March 7, 2017 at 2:52 am Loved this video!!! I am learning MySQL faster than ever because of your videos!!! Thanks Sentdex Reply Kannan Thulasi Doss says: March 12, 2017 at 6:38 pm Hi bro am a beginner i just know basics of python can i learn this straight away or do you have any prerequisite course(playlist because you have plenty of playlist) ping me asap bro Thanks Reply Stanford says: May 24, 2017 at 1:23 pm In the order of Python, we have Master Obi-Wan Ke-sentdex Reply Aashish Raina says: July 11, 2017 at 6:47 pm very well articulated Reply Markus Nesshyba says: November 15, 2017 at 3:50 am is thius still working in 2017 Reply Addison van den Hoeven says: January 22, 2018 at 2:54 pm Man, Sentdex is so awesome… Every time I take up a big project hes already gone about building a tutorial for half the tasks involved haha Reply lotfi boutebal says: February 3, 2018 at 5:24 am Hi dude i just would ask you , what about mariadb they say that its better than mysql so do i learn mariadb or sql . Even this ,what is the diffrence between mysql and sql and nosql … all those kind of same names Reply Cristian Script says: April 4, 2018 at 9:06 pm hey I am trying to send data from app inventor2 what address must I put to reach the database Reply Mr. Erik says: July 14, 2018 at 2:53 pm this dude likes to talk ALOT Reply Sujata Saini says: August 21, 2018 at 11:53 am when i running the mysql command in the bash consloe than show error "command not find".Can u help me to resolve this error Reply TheBossTheHartz says: September 12, 2018 at 12:42 pm In this vid not a word about Python, i hope the next one does what the title sais Reply MICHAEL BROWN says: September 13, 2018 at 7:30 am Hi Sentdex, I work in a lab that generates a lot of spectral data (each file can consist of 15 different columns about 4000 lines long of numerical values). There can be many parameters for each file (metal, number of laser pulses, energy used, date, user, etc.) I am thinking of building a database and using python to filter the data and display the results in various plots. I have python experience but only a tiny amount with SQL. I'm just curious if you have experience doing this with a database that would grow over time and if there is a preference between SQL, MySQL, and SQLite. Reply Jithu Nair says: November 30, 2018 at 5:44 am Was searchin' for this and came across a playlist and thought, "oh nice a compiled finished list perhaps?" Turns out, it's by the lord and saviour himself. Thanks Sentdex Sensei! <3 Reply Rashad says: March 25, 2019 at 4:21 pm I got ERROR 2005 (HY000): Unknown MySQL server host 'mysql.server' (2) after writing password on shell Reply Nana Peprah says: May 14, 2019 at 10:24 am For those having the "(HY000) error " go to your database tab and where it says Database Host Name you have to enter that entire name into the console and then proceed with the rest it should work. Reply Gorilla Cooks says: September 6, 2019 at 8:04 am WHO GOT (HY000) ERROR :1. GO TO DATABASES2. COPY Database host address (example.mysql.pythonanywhere-services.com)3. GO BACK TO YOUR BASH CONSOLE4.PUT : mysql -uYOUR_USERNAME –hexample.mysql.pythonanywhere-services.com -p that works 100% Reply Leave a Reply Cancel reply Your email address will not be published. Required fields are marked *Comment Name * Email * Save my name, email, and website in this browser for the next time I comment.