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.No | Parameter and Description |
host | Name 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″ |
user | The 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 |
password | User password must be supplied here |
Database | This 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.