Python my sql database connection

Python my sql database connection

• 1.
  Swipe Python MySQL -Database Connection
• 2.
  To connect withMySQL, (one way is to) open the MySQL command prompt in your system as shown below Python MySQL - Database Connection It asks for password here; you need to type the password you have set to the default user (root) at the time of installation.
• 3.
  Then a connectionis established with MySQL displaying the following message:- Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 4 Server version: 5.7.12-log MySQL Community Server (GPL) Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.
• 4.
  You can disconnectfrom the MySQL database any time using the exit command at mysql> prompt. mysql> exit Bye
• 5.
  Establishing connection withMySQL using python Before establishing connection to MySQL database using python, assume:- That we have created a database with name mydb. We have created a table EMPLOYEE with columns FIRST_NAME, LAST_NAME, AGE, SEX and INCOME. The credentials we are using to connect with MySQL are username: root, password: password. You can establish a connection using the connect() constructor. This accepts username, password, host and, name of the database you need to connect with (optional) and, returns an object of the MySQLConnection class.
• 6.
  Example Following is theexample of connecting with MySQL database "mydb". import mysql.connector #establishing the connection conn = mysql.connector.connect(user='root', password='password', host='127.0.0.1', database='mydb')#Creating a cursor object using the cursor() method cursor = conn.cursor()#Executing an MYSQL function using the execute() method cursor.execute("SELECT DATABASE()")# Fetch a single row using fetchone() method. data = cursor.fetchone()print("Connection established to: ",data)#Closing the connection conn.close()
• 7.
  Output On executing, thisscript produces the following output:- You can also establish connection to MySQL by passing credentials (user name, password, hostname, and database name) to connection.MySQLConnection() as shown below:- D:Python_MySQL>python EstablishCon.py Connection established to: ('mydb',) from mysql.connector import (connection) #establishing the connection conn = connection.MySQLConnection(user='root', password='password', host='127.0.0.1', database='mydb') #Closing the connection conn.close()
• 8.
  Python MySQL -Create Database Python MySQL - Create Table Python MySQL - Insert Data Topics for next Post Stay Tuned with