Python MySQLdb provides MySQLdb.connect() function to open a database connection. This function takes multiple parameters and returns a connection object to do database operations.
db = MySQLdb.connect(host, username, passwd, dbName, port, socket);
Sr.No. | Parameter & Description |
---|---|
1 |
host Optional − The host name running the database server. If not specified, then the default value will be localhost:3306. |
2 |
username Optional − The username accessing the database. If not specified, then the default will be the name of the user that owns the server process. |
3 |
passwd Optional − The password of the user accessing the database. If not specified, then the default will be an empty password. |
4 |
dbName Optional − database name on which query is to be performed. |
5 |
port Optional − the port number to attempt to connect to the MySQL server.. |
6 |
socket Optional − socket or named pipe that should be used. |
There are several other properties as well. Refer MySQLdb for complete reference.
You can disconnect from the MySQL database anytime using another connection object function close().
db.close()
Try the following example to connect to a MySQL server −
Copy and paste the following example as mysql_example.py −
#!/usr/bin/python import MySQLdb # Open database connection db = MySQLdb.connect("localhost","root","root@123") # prepare a cursor object using cursor() method cursor = db.cursor() # execute SQL query using execute() method. cursor.execute("SELECT VERSION()") # Fetch a single row using fetchone() method. data = cursor.fetchone() if data: print('Version available: ', data) else: print('Version not retrieved.') # disconnect from server db.close()
Execute the mysql_example.py script using python and verify the output.
py mysql_example.py Version available: ('8.0.23',)