Skip to main content

How to Connect Python with MySQL Database

 



How to Connect Python with MySQL Database

Today, We will learn on how to connect Python with Mysql. This tutorial will let you know how python can be used with database applications. Before starting with our tutorial, we need to have MySQL installed in your System.
You can download the MySQL database form https://www.mysql.com/downloads/

In order to connect with MySQL, Python requires Mysql Driver. So, as the next step towards database connectivity we can now install MySQL Driver. Open Command Prompt or terminal and type the following commands. We will be using PIP for faster and safer installation of the packages. 

Command to Install MySQL Connector

python -m pip install mysql-connector

Now, we have done installing Mysql Connector. Our next process is to test the installation. Let's do that by simply importing the mysql connector package.

import mysql.connector

If the above import statement did not produce any errors or warnings, then hurrah! we've successfully installed MySQL Connector.

Our Next Step is to, Create a Connection to MySQL Database:

Remember the username and password you have provided during MySQL Installation? Default username is root and Password must be left blank.

import mysql.connector

new_database = mysql.connector.connect(
  host="localhost",  
  user="root",
  passwd="" 
)

In the above code block, we have used host, user and passwd. We need to use another parameter port. This parameter is used because on some systems the default port number used by mysql database will be different. The default port used by MySQL Database is 3306. That's why we have not used the port parameter. So, if the database is on different port we need to just add the port prameter to the connector function.

import mysql.connector

new_database = mysql.connector.connect(
  host="localhost",  
  port="3308",
  user="root",
  passwd="" 
)

Now, we have successfully connected to the database. 
We'll be going through how to create a database in our next article.

Thank You.

Labels:

Comments

Post a Comment

Popular posts from this blog

Maxon Cinema 4D Studio R13.058 full Keygen Cracked Version | Mediafire Torrent Download Link

Download Maxon CINEMA 4D Studio Full Version With Keygen -Everything You Need for High-End 3D 32 and 64 bit MAXON CINEMA 4D STUDIO R13.058 (x86/x64) CINEMA 4D Studio is the very best that MAXON has to offer for professional 3D artists. If you want to create advanced 3D graphics but need a helping hand to ensure you create jaw-dropping graphics quickly and easily, then this is the choice for you.                     All You Ever Wanted This is our top-of-the-line product. It not only contains everything the other CINEMA 4D versions offer - it goes far beyond. CINEMA 4D Studio has all the tools you need to tackle even the most complex project. Minimum System Requirements Windows XP, Vista or 7 running on Intel or AMD CPU with SSE2-Support; Mac OS X 10.5.8 or higher running on an Intel-based Mac; 1024 MB free RAM, DVD ROM drive. Standard DVD installation can take up to 4 GB of disk space. Software must be registered for permanent use. SUPPORTED OPERATING SYS
2 comments
Read more

C Program to add two matrices using pointers.

  #include<stdio.h> main() { int a[5][5],b[5][5],c[5][5],i,j,m,n; printf("\n Enter the Dimension of the Matrix:\n"); scanf("%d%d",&m,&n); printf("\nEnter the Elements of the first matix:"); for(i=0;i<m;i++) { for(j=0;j<n;j++) { scanf("%d",(*(a+i)+j)); } } printf("\nEnter the elements of the second matrix:\n"); for(i=0;i<m;i++) { for(j=0;j<n;j++) { scanf("%d",(*(b+i)+j)); } } for(i=0;i<m;i++) { for(j=0;j<n;j++) { *(*(c+i)+j)=*(*(a+i)+j)+ *(*(b+i)+j); } } printf("\nResultantMatrix:\n"); for(i=0;i<m;i++) { for(j=0;j<n;j++) { printf("%5d",*(*(c+i)+j)); } printf("\n"); } getch(); } Output:  Enter the Dimension of the Matrix: 2  2 Enter the Elements of the first matix: 1   2   3   4 Enter the elements of the second matrix: 9   8   7  6 ResultantMatrix:  
Post a Comment
Read more

C Program to create a Teapot using OpenGL

  C Program to create a Teapot using OpenGL # include <stdio.h> # include <GL/glut.h> void wall ( double thickness ) { glPushMatrix ( ) ; glTranslated ( 0.5 , 0.5 * thickness , 0.5 ) ; glScaled ( 1.0 , thickness , 1.0 ) ; glutSolidCube ( 1.0 ) ; glPopMatrix ( ) ; } void tableLeg ( double thick , double len ) { glPushMatrix ( ) ; glTranslated ( 0 , len / 2 , 0 ) ; glScaled ( thick , len , thick ) ; glutSolidCube ( 1.0 ) ; glPopMatrix ( ) ; } void table ( double topWid , double topThick , double legThick , double legLen ) { glPushMatrix ( ) ; glTranslated ( 0 , legLen , 0 ) ; glScaled ( topWid , topThick , topWid ) ; glutSolidCube ( 1.0 ) ; glPopMatrix ( ) ; double dist = 0.95 * topWid / 2.0 - legThick / 2.0 ; glPushMatrix ( ) ; glTranslated ( dist , 0 , dist ) ; tableLeg ( legThick , legLen ) ; glTranslated ( 0.0 , 0.0 , - 2 * dist ) ; tableLeg ( legThick , legLen ) ; glTransla
Post a Comment
Read more