four basic sql commands and stands for create readupdateand delete connecting to mysql database from python before we can connect to mysql databasewe have to connect to the mysql server in order to do thiswe need to know the ip address of the mysql server as well as the port it is listening on we also have to be registered user with password in order to get authenticated by the mysql server you will need to have access to running mysql server instance and you also need to have administrator privileges in order to create databases and tables there is free mysql community edition available from the official mysql website you can download and install it on your local pc from :ttp://dev mysql com/downloads in order to connect to mysqlwe first need to install special python connector driver this driver will enable us to talk to the mysql server from python the driver is freely available on the mysql website and comes with very nice online tutorial you can install it from there is currently little bit of surprise at the end of the installation process when we start the msi installer we briefly see messagebox showing the progress of the installationbut then it disappears we get no confirmation that the installation actually succeeded one way to verify that we installed the correct driverthat lets python talk to mysqlis by looking into the python site-packages directory if your site-packages directory looks similar to the following screenshot and you see some new files that havemysql_connector_python in their namewellthen we did indeed install something the official mysql website mentioned above comes with tutorialat the following url: import mysql connector as mysql conn mysql connect(user=password=host= 'print(connconn close(