MySQL Connection


You can establish the MySQL database using the mysql binary at the command prompt.

Example

Here is a simple example to connect to the MySQL server from the command prompt −

[root@host]# mysql -u root -p
Enter password:******

This will give you the mysql> command prompt where you will be able to execute any SQL command. Following is the result of above command −
The following code block shows the result of above code −

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2854760 to server version: 5.0.9

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

In the above example, we have used root as a user but you can use any other user as well. Any user will be able to perform all the SQL operations, which are allowed to that user.

You can disconnect from the MySQL database any time using the exit command at mysql> prompt.

mysql> exit
Bye

MySQL Connection Using Python Script
Python uses mysql connector module to open a database connection. in order to make a connection between these two, MySQL link identifier on success or FALSE on failure. The syntax is as follows
Syntax

mysql.connector.connect(host='localhost',
  user='root',password='userpassword',database="databasename")

Here are are

S.NoParameter and Description
hostName of the server. Most of the time it is localhost as you are running it on your own system at port no 3306. If you are running it at a different post then this should be like this

host =”localhost:3307″

userThe user name is supplied here. In the above example, we used the default user name but you can log in using your own login ID
passwordUser password must be supplied here
DatabaseThis is optional. It is required when you are sure all your operations will be performed on the selected database only.

You can disconnect from the MySQL database anytime using another close() function. All you need the connection string and close function

db.close()

Python Program to connect with MySQL

Python MySQL connector module is required to connect with MySQL.

Example

Try the following example to connect to a MySQL server −

import mysql.connector
conn = mysql.connector.connect(host='localhost',user='root',password='')
cursor = conn.cursor()
cursor.execute('create database rakesh;')
conn.close()
print('database created successfully')

The program not only make connection between Python and MySQL but also generate a database ‘rakesh’ inside our MySQL database.

Print Friendly, PDF & Email

Related Posts

If you like CBSEToaday and would like to contribute, you can also write an article using submit article or mail your article to contribute@cbsetoday.com See your article appearing on the cbsetoday.com main page and help other students/teachers.