If you are facing any issue in playing video please use Firefox browser.
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.
MySQL IDE :
MySQL Connector :
Python version :
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.
Have a friend to whom you would want to share this course?