Course Content

If you are facing any issue in playing video please use Firefox browser.

Course Content

Description

Python MySQL Database

 

In this lecture we will see that,

What is database ?

Which are the software requirement for database ?

How to install MySQL and MySQL connector ?

 

Database is very important topic. When we want to store a data, what options do we have in Python, we have lists, files etc...

 

Python database API supports a wide range of database service such as -

MySQL, GadFly, mSQL, PostgreSQL, Microsoft SQL server 2000, Informix, Interbase, Oracle, Sybase.

 

Language :

MySQL

MySQL-essential-6.0.0

 

MySQL IDE :

SqlYog

 

MySQL Connector :

MySQL-connector-python-2.1.7-py3,4-windows-×86-64bit

 

Python version :

3.4

 

First of all you will need to install 'MySQL-essential', and than we will configure it. For that we will go to windows and search 'MySQL server interface configuration wizard'. Click it and proceed with configuration, in between we will select our port number and save it with us for later.

 

Then we will select the service name, and save it with us. After that the most important part comes, which is you need to provide your username and password. We'll proceed by clicking next and finish. So this is how you configure MySQL.

 

Now we will install SqlYog from it's installer, after that when will proceed we will need all our details which we had saved with us while configuring MySQL for connecting MySQL Host.

 

Now we want to run our Python with MySQL so for that we will use MySQL connector python. So we'll install that also.

 

 

FAQs

Share With Friend

Have a friend to whom you would want to share this course?

Download The Apps

Code Scan or Download the app
Google Play Store
297K+ Downloads
4.5 Rating
10K+ Reviews
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere